| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Actual value a non-zero number but display is Zero
Hi,
In A1 i have the value 1, In B1 let's say 2 and C1 value 3 and in D1 I have a formula = A1+B1+C1. I want to print the range A1 to D1 and see the value 6 in D1 but in A1 to C1 I want the excel display to be zero. I have probably read in thi group that some folks use rightclick on cell and use Format and use some variation of Custom to achieve this (not very sure). Please guide me. Please Regards, Hari India |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display ONLY fraction portion of number | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| How do I subtract with text valued number instead of an actual num | Excel Worksheet Functions | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Axis display as category | Charts and Charting in Excel | |||
Threaded Mode
