M
Mark
how can I format cell so when I want to enter, say, time I just type
1427 and it will come as 14:27?
thanks for any response,
Mark
1427 and it will come as 14:27?
thanks for any response,
Mark
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
G
Gord Dibben
Mark
If you wish for 14:27 to be a usable time, you cannot format.
You must use VBA code to convert the 1427 to 14:27
Chip Pearson has code for this........
http://www.cpearson.com/excel/DateTimeEntry.htm
If you just want it to be text 14:27 you can format the cell(s) as Custom
##":"##
Gord Dibben Excel MVP
If you wish for 14:27 to be a usable time, you cannot format.
You must use VBA code to convert the 1427 to 14:27
Chip Pearson has code for this........
http://www.cpearson.com/excel/DateTimeEntry.htm
If you just want it to be text 14:27 you can format the cell(s) as Custom
##":"##
Gord Dibben Excel MVP
M
Mark
Thank you guys
Mark
Mark
K
kimboyd
To format numbers in a cell click on format. Click cells
to format the contents of the cell(s). Choose the number
tab and (in your case) scroll down to the time function.
Kim Boyd
to format the contents of the cell(s). Choose the number
tab and (in your case) scroll down to the time function.
Kim Boyd
P
Peo Sjoblom
Did you try that with 1427 coming out as 14:27?
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)