Thread: 16 digits
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jane
 
Posts: n/a
Default 16 digits

Thanks, Dave and Mark, for the quick response. I'm sorry to hear the answer,
but will cope with it!

"Dave O" wrote:

Excel can't handle numbers of that size without reverting to scientific
notation. Do you have to do math on these numbers, or are the account
numbers, or credit card numbers, or something that won't require math?
If yes, format the cells as text.