| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to display zero at the left hand of a code in a cell say 045
\0 will give you a leading zero but you must follow it with as many # signs
as you think you might need. It will not display unwanted zeroes. 025 will display as 025 and not 000025. "Marie" wrote: In a cell I need to show codes with a zero at the left, how can do this without having to format it as text first? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
