| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enter number in a cell and it is to display time.
I have tried everything to format the cell. What I want to do is enter 1005
and in the cell it reads 10:05. I have tried [h]:mm, 13:30, and many other combinations. It either displays 0:00 or 00:00 or 10/1/1902 12:00:00 AM. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting a cell to display a word when i enter a reference lette | Excel Discussion (Misc queries) | |||
| Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
| Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
