Entering Time without the colon.......

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like for a user to enter a time without the colon, for example, 1045, and have it appear in the cell as 10:45. Is this possible?
 
See:

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

it takes VBA

A non macro solution would be to use the numpad and temporary change
autocorrect
.. (period) to : (colon) that way you can use your right hand to type
with

--

Regards,

Peo Sjoblom

SCExcel said:
I would like for a user to enter a time without the colon, for example,
Click to expand...
1045, and have it appear in the cell as 10:45. Is this possible?
 
Right-click on the cell(s) > Format Cells > Custom > type ##":"## in
the window > ok

Vaya con Dios,
Chuck, CABGx3



SCExcel said:
I would like for a user to enter a time without the colon, for example,
Click to expand...
1045, and have it appear in the cell as 10:45. Is this possible?
 
Hi Charles,

it will only change the display, the underlying value would still be one
1,045
 
Thank you.......

----- CLR wrote: -----

Right-click on the cell(s) > Format Cells > Custom > type ##":"## in
the window > ok

Vaya con Dios,
Chuck, CABGx3



SCExcel said:
I would like for a user to enter a time without the colon, for example,
Click to expand...
1045, and have it appear in the cell as 10:45. Is this possible?
 
Back
Top