Project Detail

Excel .csv add-in for format changes

Excel .csv add-in for format changes is project number 265131
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: tusharvv

Budget: $30-250

Created: 05/22/2008 at 3:50 EDT

Bid Count: 10

Average Bid:
$ 60

05/23/2008 at 3:50 EDT

Project Creator: jonjonsson
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (8 reviews)

Description

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.

Report Violation

Job Type

See more: data, excel, file, format, number, press, text, windows

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

05-22-2008 04:31 EDT

9.2727/10
(22 reviews)

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.

tusharvv

2 days

05-22-2008 12:25 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(10 reviews)

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

guolibin

2 days

05-22-2008 04:04 EDT

9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10
(10 reviews)

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

consus

2 days

05-22-2008 17:20 EDT

9.7778/10
(9 reviews)

Hello sir Please check your PMB for Bid details Thanks

azrajobs

1 day

05-23-2008 04:05 EDT

9.6/10 9.6/10 9.6/10 9.6/10 9.6/10 9.6/10 9.6/10 9.6/10 9.6/10 9.6/10
(5 reviews)

pzl view pm

trian

1 day

05-22-2008 13:09 EDT

9.4/10 9.4/10 9.4/10 9.4/10 9.4/10 9.4/10 9.4/10 9.4/10 9.4/10 9.4/10
(5 reviews)

Hello. Ready for this job.

jolly5676

2 days

05-22-2008 12:10 EDT

(No Feedback Yet)

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

lchwzh

2 days

05-22-2008 09:03 EDT

(No Feedback Yet)

Let's begin!

madkoor911

4 days

05-22-2008 09:40 EDT

(No Feedback Yet)

I think i can help you

hnhltd2

130

7 days

05-23-2008 02:48 EDT

(No Feedback Yet)

Please check PMB

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.