Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MAXIMUM NUMBERS IN CELL
When entering more than 15 numbers in a cell, Exel automatically changes the
integers after 15 to a zero. Example: 123456789123456789 entered into cell returns 123456789123456000. Is there any way around this? Thanx |
#2
|
|||
|
|||
Excel supports only 15 digits, but if you don't want to do any calculations
on these numbers, then you can enter them as strings. A preceding ' will convert numbers to string. e.g. '123456789123456789 is treated as a text string. - Mangesh -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the maximum text size in a cell | Excel Discussion (Misc queries) | |||
can you perform a character count per cell with numbers? | Excel Discussion (Misc queries) | |||
How can I write in a text in a cell using numbers and the letters. | Excel Discussion (Misc queries) | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Cell value as chart scale maximum | Charts and Charting in Excel |