how to put a number with more than 15 digits in a cell

P

Pete_UK

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
 
Top