| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display 1.6 as 1 (0 D.P.) instead of 2?
Hi Without using an extra column, you can't. Even with VBA, if you run code to change the appearance of the cells, the underlying values themselves would alter. -- Roger Govier ------------------------------------------------------------------------ Roger Govier's Profile: http://www.thecodecage.com/forumz/member.php?userid=81 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82544 |
| Reply |
| 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 | |||
![Roger Govier[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
