-
January 27th, 2005, 06:15 AM
#1
Excel losing number format when converting to csv
I am involved in a project currently which requires multiple xls files to be saved in csv format for ftp-ing to a server in the US. One of the spreadsheet columns contains a long integer which is held in a General number format, but appears in the resulting csv files in scientific notation (e.g. 5.01225E+12). A lot of these files are ending up corrupted on the ftp server with all the integer values appearing as 05012250000000 whatever their starting value was.
According to a Microsoft knowledge article, storing the number in the General format should cure this known issue, but the values are already in this format. Anyone know of a workaround? Currently using Excel 2002 running under Windows XP.
Cheers!
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|