format cell

[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

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/DateTimeEntry.htm
this requires VBA

 

[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

 

[Mark]

Thank you guys
Mark

 

[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

 

[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)