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

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


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.


Start with an apostrophe (').

As noted above, this makes a text value, not numeric. You can’t do
arithmetic with it the way you may expect.