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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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')
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to STOP Excel from changing my data 1
How do I stop Excel 2007 from using scientific notation? 2
Excel Number Conversions 2
how i dow the following formal in excel 6
Adding Quote Marks To A Very Long Column. How, Please ? 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excel And Notepad 3
how do I change a csv extension file to an xls file and use it? 1

Back
Top