| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display 0 in the cells...
..
hi all, i'm trying to show "0" in a cell with successor as any other number. i don want to convert the cell as text, or to add a hyphen before 0, like " '05 ". Please let me know how to solve this. Regards, Divy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display 0 in the cells...
how many digits in the numbers you want to precede with a zero?
go to format cells, choose custom, enter 0### if you want up to 3 digit numbers to be preceded by a zero -- Gary "Divy" wrote in message oups.com... . hi all, i'm trying to show "0" in a cell with successor as any other number. i don want to convert the cell as text, or to add a hyphen before 0, like " '05 ". Please let me know how to solve this. Regards, Divy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells display as R5C5. How do I change it to display E5? | Excel Discussion (Misc queries) | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Why does my formula bar display a lengthy string, but my cells display #####? | Excel Programming | |||
Hybrid Mode
