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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How to create a bubble chart with more than 2 variables. 0
I cannot enter a number containing more than 15 digits in Excel 1
Adding an apostrophe to a column of numbers 5
Change a great number of words in word files, with a macro as short as possible. 5
end a number in ZERO 3
Showing 18 digits or more in a cell 2
Word macro that can call cells out of Excel for a find and replace 0

Top