Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I have an initial zero in an Excel cell?
I want to be able to enter times as eg 0845 but no matter what cell format I
use, there is a problem, either that the initial zero is lopped off or that I am informed there is an error. Is there any way of solving this? |
#2
|
|||
|
|||
How can I have an initial zero in an Excel cell?
try
<format<cell<number<custom enter 0000 and you will get a four digit display with an initial display with a leading zero. Note this is not a time function "ALupin" wrote: I want to be able to enter times as eg 0845 but no matter what cell format I use, there is a problem, either that the initial zero is lopped off or that I am informed there is an error. Is there any way of solving this? |
#3
|
|||
|
|||
How can I have an initial zero in an Excel cell?
I use Format, Cells, Number tab, select "Custom" format and select the "0"
just below "General"; then I add three zeros to the "0" displayed in "Type" and this format is then available for use. "bj" wrote: try <format<cell<number<custom enter 0000 and you will get a four digit display with an initial display with a leading zero. Note this is not a time function "ALupin" wrote: I want to be able to enter times as eg 0845 but no matter what cell format I use, there is a problem, either that the initial zero is lopped off or that I am informed there is an error. Is there any way of solving this? |
#4
|
|||
|
|||
How can I have an initial zero in an Excel cell?
Brilliant, Hairy Hurdler - many, many thanks. This has been foxing me for
over a year!! "Hairy Hurdler" wrote: I use Format, Cells, Number tab, select "Custom" format and select the "0" just below "General"; then I add three zeros to the "0" displayed in "Type" and this format is then available for use. "bj" wrote: try <format<cell<number<custom enter 0000 and you will get a four digit display with an initial display with a leading zero. Note this is not a time function "ALupin" wrote: I want to be able to enter times as eg 0845 but no matter what cell format I use, there is a problem, either that the initial zero is lopped off or that I am informed there is an error. Is there any way of solving this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I have an initial zero in an Excel cell?
BUT when you save the file and go back to it the number looks the same but
the format has changed from 0000 to Greek !! Anybody else had this problemo ? It screws the cell format for later merging to other documents I've found. "bj" wrote: try <format<cell<number<custom enter 0000 and you will get a four digit display with an initial display with a leading zero. Note this is not a time function "ALupin" wrote: I want to be able to enter times as eg 0845 but no matter what cell format I use, there is a problem, either that the initial zero is lopped off or that I am informed there is an error. Is there any way of solving this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |