Sedang Disiapkan

Excel .csv add-in for format changes

I need a utility or a add-in that can when pressing on a .csv files to changes the format of the fields in Excel.

-

The problem at the moment is for example if importing the following file:

00032323 32-32-3223 abcd dfdsfds 123

Then Excel automatically changes the format of the fields to

Number, Date, Char, char, Number

I need a utility that will automatically when double clicking on .csv files in Windows put the data in the format as for example:

00032323 32-32-3223 abcd dfdsfds 123

text text text text number

So the logic is when there are leading zeros the fields become text and if there are "-" in the number or text the field becomes a text not a date.

I need a utility that will do this automatically when double clicking on the .csv file in Windows, I don't want a utility where I have to press a button or run through some kind of filter before, needs to be automatic.

Kemahiran: .NET, Pengaturcaraan C, Delphi, Excel

Lihat lebih lanjut: excel csv add, excel add csv, excel csv addin, csv excel add, csv add excel, csv add, view csv original format excel, excel add est, csv add sign, need format, excel &, date utility, data pressing, excel csv changes date, util open csv excel, csv add formatting, excel data format add net, excel csv format numbers, xla addin utility, excel csv double click cells show standard format, delphi excel numberformat, automatically format csv, excel numberformat delphi format possible, excel csv change date format, adding number formating csv

Tentang Majikan:
( 11 ulasan ) London, United Kingdom

ID Projek: #265131

Dianugerahkan kepada:

refractocd

We can create a .xla addin which will do the needful. Btw, you have provided excellent description for a programmer.

$35 USD dalam 2 hari
(10 Ulasan)
3.7

10 pekerja bebas membida secara purata $60 untuk pekerjaan ini

consus

Hello sir Please check your PMB for Bid details Thanks

$90 USD dalam 2 hari
(17 Ulasan)
6.4
riyoyo

On your Excel Add-In, you should catch the Workbook_Open event for processing that data formats. So, when you double click any csv files, your cell will be formatted like that. Contact me and I will show you a demo.

$75 USD dalam 0 hari
(22 Ulasan)
6.2
azrajobs

pzl view pm

$50 USD dalam sehari
(32 Ulasan)
5.1
trian

Hello. Ready for this job.

$30 USD dalam sehari
(3 Ulasan)
4.1
guolibin

Hello I can create a add-in for your requirement. I'll use vb to develop it. I'm looking forward to work with you. Best regards. Libin

$80 USD dalam 2 hari
(1 Ulasan)
2.0
jolly5676

This can be done using VBA in excel .I have dealt with .csv file a lot.i am the right person Regards Jolly

$30 USD dalam 2 hari
(0 Ulasan)
0.0
lchwzh

Let's begin!

$30 USD dalam 2 hari
(0 Ulasan)
0.0
madkoor911

I think i can help you

$50 USD dalam 4 hari
(0 Ulasan)
0.0
hnhltd2

Please check PMB

$130 USD dalam 7 hari
(1 Ulasan)
0.0