I gang

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.

Færdigheder: .NET, C programmering, Delphi, Excel

Se mere: excel csv add, excel add csv, excel csv addin, csv excel add, csv add excel, csv add, excel add est, csv add sign, need format, date utility, data pressing, excel csv changes date, util open csv excel, csv add formatting, excel csv format numbers, xla addin utility, delphi excel numberformat, automatically format csv, adding number formating csv, excel format csv event, excel csv date format, excel addin export csv, view number csv excel, changes excel csv format, excel add number format

Om arbejdsgiveren:
( 11 bedømmelser ) London, United Kingdom

Projekt-ID: #265131

Tildelt til:

refractocd

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

$35 USD in 2 dage
(10 bedømmelser)
3.7

10 freelancere byder i gennemsnit $60 for dette job

consus

Hello sir Please check your PMB for Bid details Thanks

$90 USD in 2 dage
(17 bedømmelser)
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 in 0 dage
(22 bedømmelser)
6.2
azrajobs

pzl view pm

$50 USD på 1 dag
(32 bedømmelser)
5.1
trian

Hello. Ready for this job.

$30 USD på 1 dag
(3 bedømmelser)
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 in 2 dage
(1 bedømmelse)
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 in 2 dage
(0 bedømmelser)
0.0
lchwzh

Let's begin!

$30 USD in 2 dage
(0 bedømmelser)
0.0
madkoor911

I think i can help you

$50 USD in 4 dage
(0 bedømmelser)
0.0
hnhltd2

Please check PMB

$130 USD in 7 dage
(1 bedømmelse)
0.0