Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DECIMAL PLACES DISPLAYED
I'm having a problem with how my decimal places are displayed in the
"Formula Bar". I have the number of decimal places set to three for all of the cells in my spreadsheet, but in certain instances, only one or two places are all thats being displayed in the Formula Bar. An example would be 0.500 (in the cell), but 0.5 is displayed in the Formula Bar. Can someone please head me in the right direction? Thanks, Tom T. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DECIMAL PLACES DISPLAYED
the formulabar will show significant digits only. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Tom wrote : I'm having a problem with how my decimal places are displayed in the "Formula Bar". I have the number of decimal places set to three for all of the cells in my spreadsheet, but in certain instances, only one or two places are all thats being displayed in the Formula Bar. An example would be 0.500 (in the cell), but 0.5 is displayed in the Formula Bar. Can someone please head me in the right direction? Thanks, Tom T. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DECIMAL PLACES DISPLAYED
The formula bar doesn't append zeros to the end of a value. Since 0.5
defines the value stored in the cell, that is what it displays. It doesn't observe how you have formatted the cell. if the number were entered as 3.12345 it would appear in the cell as 3.123 but the formula bar would show you what is actually stored in the cell: 3.12345 -- Regards, Tom Ogilvy "Tom" wrote in message om... I'm having a problem with how my decimal places are displayed in the "Formula Bar". I have the number of decimal places set to three for all of the cells in my spreadsheet, but in certain instances, only one or two places are all thats being displayed in the Formula Bar. An example would be 0.500 (in the cell), but 0.5 is displayed in the Formula Bar. Can someone please head me in the right direction? Thanks, Tom T. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal places | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Automaticallychanging the number of decimal places displayed | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) |