ExcelBanter - cell assumes wrong date

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - cell assumes wrong date (https://www.excelbanter.com/setting-up-configuration-excel/4951-cell-assumes-wrong-date.html)

cell assumes wrong date

I want to format a cell for time. I want to type "0830" in a cell and have it
show 8:30 AM. So I format the cell accordingly. But when I type 0830 in the
cell I get "12:00 AM", and if I double click into the cell it shows "4/9/1902
12:00:00 AM". What can I do to have it not include a date...just a time?

You can't unless you use a macro, see:

http://www.cpearson.com/excel/DateTimeEntry.htm

One day is 1, one hour is 1/24 no formatting can change 830x24 hours into
08:30, you need the above macro

Regards,

Peo Sjoblom

"julie from Seattle" wrote:

I want to format a cell for time. I want to type "0830" in a cell and have it
show 8:30 AM. So I format the cell accordingly. But when I type 0830 in the
cell I get "12:00 AM", and if I double click into the cell it shows "4/9/1902
12:00:00 AM". What can I do to have it not include a date...just a time?