View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
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: