| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change decimal format of cells depending on conditions?
Hi all. I'm looking to change the format of cells to two-decimals when they represent price per pound, but switch to comma-format when otherwise. This is because the sheet shows lbs, dollars or price depending on the switch selected, or combinations of them in different areas, and the lbs and dollars columes are in the millions (decimals are confusing to the audience in this case). Thanks ccc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
| Change format of cells | Excel Worksheet Functions | |||
| Change format of cells | Excel Worksheet Functions | |||
Threaded Mode
