Thread: when I type a long number it shows up as smaller number and +
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default when I type a long number it shows up as smaller number and +
Yes, just specify the format that you want.
Format Cells...Number0 decimal places

Regards,
Fred


"SandyC" wrote in message
...
when converting from xls to csv format, some of my longer mortgage numbers
get condensed into a smaller number with a letter, a plus sign and another
number. example: 100020013120 turns into 1.0002E+11. Any way to get
rid
of this? Thanks,

Reply With QuoteReply With Quote