Excel to CSV conversion error

  • Thread starter Thread starter Gnana
  • Start date Start date
G

Gnana

When i type this below numbers in Excel 2003
21000000000147704
21000000000147677
21000000000147663
and save as CSV and open it replaced with this below values,
21000000000147700
21000000000147600
21000000000147600
can you please suggest how i can solve this problem.
 
It's because the max length of numbers in Excel is 15 digits. Format cells as
Text BEFORE entering values in them!

Regards,
Stefi


„Gnana†ezt írta:
 
It's because the max length of numbers in Excel is 15 digits. Format cellsas
Text BEFORE entering values in them!

Regards,
Stefi

"Gnana" ezt írta:
Click to expand...

It works with .xls format, but i have to save as .csv and .csv format
not discards all formating.
So how can i solve this problem in .csv formated file.

Thanks,
Gnana
 
I found a little bit complicated way:
1. Rename your .csv file to .txt
2. Open it, choose separated style, select comma (or semicolon according to
your regional settings) as separator
3. Change column type from General to text for column containing these long
numbers.

Not a very convenient way, but I do not know any better one!

Regards,
Stefi


„[email protected]†ezt írta:
 
Back
Top