View Single Post
  #2  
Old June 3rd, 2010, 10:07 AM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default how to put a number with more than 15 digits in a cell

You have to enter it as a text value. Either pre-format the cell as
text and then type your number, or include an apostrophe when you type
the number, like:

'1234567890123456789

The apostrophe will not show in the cell.

Hope this helps.

Pete

On Jun 3, 9:39*am, Shehzad wrote: