Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal points data not displaying as expected
When entering the following number in Excel it doesn't display correctly
either in the cell or the formula bar - Cell is formatted as Number with 9 decimal points. I enter this number: 287488758463.904876 Cell displays: 287488758463.905000000 Formula Bar displays: 287488758463.905 How can I get it to display exactly what is typed into the cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal points data not displaying as expected
Excel has a 15 digit limit on numeric precision.
Preface the entry with an apostrophe. You won't be able to do calculations but your data will be displayed as you wish. For more on Excel limits etc. se help on "specifications" Gord Dibben MS Excel MVP On Sun, 20 Jul 2008 17:54:15 -0700, g. spence wrote: When entering the following number in Excel it doesn't display correctly either in the cell or the formula bar - Cell is formatted as Number with 9 decimal points. I enter this number: 287488758463.904876 Cell displays: 287488758463.905000000 Formula Bar displays: 287488758463.905 How can I get it to display exactly what is typed into the cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal points data not displaying as expected
By using an apostrophe, the cell data goes from being a number to a
string, therefore in order to use the cell for caculations, you must revert the cell information back to a number from the string afterwards. In VBA this is done by using val(string). On 7$B7n(B21$BF|(B, $B8aA0(B10:04, Gord Dibben <gorddibbATshawDOTca wrote: Excel has a 15 digit limit on numeric precision. Preface the entry with an apostrophe. You won't be able to do calculations but your data will be displayed as you wish. For more on Excel limits etc. se help on "specifications" Gord Dibben MS Excel MVP On Sun, 20 Jul 2008 17:54:15 -0700, g. spence wrote: When entering the following number in Excel it doesn't display correctly either in the cell or the formula bar - Cell is formatted as Number with 9 decimal points. I enter this number: 287488758463.904876 Cell displays: 287488758463.905000000 Formula Bar displays: 287488758463.905 How can I get it to display exactly what is typed into the cell?- $B0zMQ%F%-%9%H$rI=<($7$J$$(B - - $B0zMQ%F%-%9%H$rI=<((B - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
Column chart not displaying some data points - Excel 2003 | Charts and Charting in Excel | |||
Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
Add data labels without displaying data points? | Charts and Charting in Excel | |||
Decimal Points | Excel Worksheet Functions |