Help Please With Tab Delimited files.......excel 2003

  • Thread starter Thread starter Dave T
  • Start date Start date
D

Dave T

Okay i pretty new to Excel (office version 2003) , i need to make and save
some tab delimited files , No probs , but when i load them back up , for
example a long number such as :- 5031366015174 saves okay and is fine in its
delimited text file , but when i load the tab delimited file back into excel
the long number has become 5.03137E+12 , so when i save it again after
adding more data to the list , the number is no long any use ?!?! any way to
stop this please.

When i load the file back into excel i choose delimited , file origin
ms-dos(pc-8), delimiter tab,column data general , all other boxes unticked ,
these are the standard defaults.

Its driving me round the twist , as the data saved is okay the first time ,
but when you load the data back up into excel the long number is useless?

Any help or advice please
 
When you load the file back in, widen the column and format as
General.

Hope this helps.

Pete
 
Dave T said:
Hi Peter , thank you once again :)
Click to expand...
Hi peter , just a quick one , i had to format the sell as number and then
change decimal places to 0 for it to work...but thank you for pointing me in
the right direction.
 
Back
Top