| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LEADING ZEROS IN FORMULA RESULT
I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to no avail. I have two cell that I would like to combine into one cell. Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is killing me. Any quick help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
| How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Threaded Mode
