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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to put a number with more than 15 digits in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/265134-how-put-number-more-than-15-digits-cell.html)

Shehzad

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

Pete_UK

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:

All times are GMT +1. The time now is 06:36 PM.