| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel time format
How can i format a cell that will display the ime as 08:00 when i enter 8? i
have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Excel charts should have format templates | Charts and Charting in Excel | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Threaded Mode
