| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display 1.6 as 1 (0 D.P.) instead of 2?
I have some cells which use a decimal place to act as a postfix. Eg. I want
1.1, 2.1, 3.1 , then further down 1.2,2.2,3.2... .I want the Integer part to be displayed and hide the postfix part,using cell format, but when the postfix reaches 0.6 excel rounds up and displays the number as 2 (0 DP) when it should be displayed as 1. I dont want to use formulae/hidden column etc. any suggestions? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
| Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel | |||
Threaded Mode
