.xsl to .csv number format problem

[ljwmis]

I've got an Excel 2003 spreadsheet coming form two sources of data. One set is fine and showing numbers or a mixture of numbers and text,

i.e. 0020201000400011 or 0020201000400011C

However, the second set of data is showing numbers as

2.0201E+13

I've converted then in the spreadsheet by using Format / Cells / Custom / #,##0

Then Format / Cells - uncheck the Use 1000 Separator(,)

This displays the number as 20202004000036

Thats great all the numbers are the same in excel, access etc.

However, I need to put the data in a .csv file and despite my best efforts it always displayes the number as 2.0201E+13!

Any ideas?

 

[SkipVought]

Hi,

If your data is numeric, then it should make no difference how the number is formatted. Its just a number!

However, if your data is not meant for arithmetic operations, then why do you have the data stored as a number? Store it as TEXT and everything will me peachy!

faq68-6659.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[robmazco]

or something simpler? maybe the column needs to be expanded to fit all the numbers in?

 

[xlhelp]

or something simpler? maybe the column needs to be expanded to fit all the numbers in?

Wrong tree.

Since CSV file by nature doesn't formatting applied, Excel with default formatting of General, applies the formatting it sees fit. No you have to go through a few hopps to do what OP wants.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents