|
Posted to microsoft.public.excel.newusers
|
|
|
excel time format
see
http://cpearson.com/excel/DateTimeEntry.htm
In article ,
JarvisC wrote:
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.
|