Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel is changing the last digit to 0
I am trying to enter some numbers into an excel spreadsheet and the program
keeps changing my last digit to 0. These are 16 digit numbers. Is there any way to fix this? What is going on? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel is changing the last digit to 0
Excel is limited to 15-digit precision. To enter longer numbers,
precede the number with an apostrophe. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Heather Lisco" wrote in message ... I am trying to enter some numbers into an excel spreadsheet and the program keeps changing my last digit to 0. These are 16 digit numbers. Is there any way to fix this? What is going on? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel is changing the last digit to 0
Thanks Chip!!!
"Chip Pearson" wrote: Excel is limited to 15-digit precision. To enter longer numbers, precede the number with an apostrophe. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Heather Lisco" wrote in message ... I am trying to enter some numbers into an excel spreadsheet and the program keeps changing my last digit to 0. These are 16 digit numbers. Is there any way to fix this? What is going on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Changing Numbers Automatically | Excel Discussion (Misc queries) | |||
Open Excel in a browser without changing URL | Excel Discussion (Misc queries) | |||
excel changing after 15th digit the numbers into zero's | Excel Discussion (Misc queries) | |||
Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) |