View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Number changes to formula

Number can only be 15 digits long. Large numbers are usually shown in
scientific format when using General format. If you want the number to show
you will need to format it as text before you enter the number, or precede
your number with an apostrephe like so
'1234567890123456
(NOTE: The apostrophe won't show)


"nohotin" wrote:

When I paste a credit card number into Excel spreadsheet, it either changes
it to a formula (like 4.22242223242452+15) or rounds the last two digits UP.
I've tried ALL the number formats, and it still happens.