Saving Excel 2003 worksheet to .csv format changes dates & ph numbers

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

genevieve68

Thread Starter
Joined
Apr 7, 2010
Messages
1
I am exporting report data from an accounting program into Excel 2003, then having to change some of the worksheet data into to a specific format (some columns show dates, phone numbers, etc - which need to be converted to text - translation:HEADACHE) and then saving file as ".csv" to submit reports online to another agency. I am pulling my hair out here because it keeps changing to funky formats in the .csv sheet and I find myself back at square one. I am required to do this on a monthly basis, and will soon be submitting a similar file to a different agency, so I will double my headache if I can't get my head wrappred around this.

Any help would be great!!!

Thanks.



I'm running XP Pro sp3, Office 2003
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top