Thread: 15 digets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default 15 digets

Excel has a limit of 15 digits. If your are working with really big
umbers - meaning you want to do arithmetic operations on these numbers -
then Excel is not for you. But if they are nor true numbers (ie things like
credit card numbers) then they can be entered as text by
1) first formatting the cell as Text
OT 2) typing a single apostrophe before the 'number' - the apostrophe will
not display in the cell, nor will it appear in a print out.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"lostsoul62" wrote in message
...
I'm trying to put in a 15 diget number and it keeps turning the last
number
to zero. I'm using excel 2007. Under format cell, I use numbers