View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default excel, how enter 15 digits in a cell without rounding off last?

You can't enter a numeric value 15 digits so you need to format the cell as
TEXT but obviously you cannot use this for calculations.

Not for Credit Card Number by any chance?

HTH

"mike marcus" wrote:

How can I enter over 15 digits in a cell without it rounding off the excess
digits?