GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Excel .csv add-in for format changes

   Click here to post similar project

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

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider tusharvv
Budget: $30-250
Created: 05/22/2008 at 3:50 EDT
Bidding Ends: 05/23/2008 at 3:50 EDT
Project Creator: jonjonsson View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(6 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:
  • .NET
  • C/C++
  • Delphi
  • Excel
Database: (None)
Operating system: MS Windows
Bid count: 10
Average bid: $ 60

 

Related project
 
Nonpublic project #302982 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
guolibin
View PM Post PM
$ 80 2 days 05-22-2008 04:04 EDT 9.70/109.70/109.70/109.70/109.70/109.70/109.70/109.70/109.70/109.70/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
azrajobs
View PM Post PM
$ 50 1 day 05-23-2008 04:05 EDT 9.60/109.60/109.60/109.60/109.60/109.60/109.60/109.60/109.60/109.60/10
(5 reviews)
pzl view pm
consus
View PM Post PM
$ 90 2 days 05-22-2008 17:20 EDT 9.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/10
(4 reviews)
Hello sir Please check your PMB for Bid details Thanks
trian
View PM Post PM
$ 30 1 day 05-22-2008 13:09 EDT 9.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/10
(3 reviews)
Hello. Ready for this job.
tusharvv
View PM Post PM
$ 35 2 days 05-22-2008 12:25 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
We can create a .xla addin which will do the needful. Btw, you have provided excellent description for a programmer.
riyoyo
View PM Post PM
$ 75 0 days 05-22-2008 04:31 EDT 8.93/108.93/108.93/108.93/108.93/108.93/108.93/108.93/108.93/108.93/10
(14 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.
jolly5676
View PM Post PM
$ 30 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
View PM Post PM
$ 30 2 days 05-22-2008 09:03 EDT (No Feedback Yet)
Let's begin!
madkoor911
View PM Post PM
$ 50 4 days 05-22-2008 09:40 EDT (No Feedback Yet)
I think i can help you
hnhltd2
View PM Post PM
$ 130 7 days 05-23-2008 02:48 EDT (No Feedback Yet)
Please check PMB
Bid on This Project

 

[ Website Design ] [ Outsourcing Web Design ] [ Outsourcing ] [ Web Forms ] [ Freelance ]

What is GetAFreelancer.com? ( Read about the company )

Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%. We provide a safe escrow environment and you don't release the money until project is completed. A freelancer is an independent worker, not on salary, hired instead on a project basis. Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. We have thousands of satisfied clients around the world.

Deposit money and don't purchase until your project is completed. It's easy, fun and very affordable to outsource your project with our site. GetAFreelancer.com is one of the largest sites of its kind. We have earned a good reputation and you can trust us. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.