How do I stop Excel from changing 02117240000 into 2.11724E+11 in.

B

BrendaC

I am working with files, trying to convert electronic billings into *.csv
files for a customer. It seems to work but when I re-open the file, all of my
customer's cost center numbers change from what they are supposed to be (i.e.
0211724000000) to something like 2.11724E+11

How do I stop the numbers from changing?

Thanks
 
F

Frank Kabel

Hi
try formating these numbers as 'Text'. also saving the file as *.txt
file may help as Excel will ask you for the type of this column in this
case (and you can choose 'Text')
 
D

Dave Peterson

Or just apply a Number format that you like after you import the file.

(If the number of digits in your fields exceeds 15, then you'll want to treat
the values as text--excel only keeps track of 15 significant digits.)
 
Top