Hi, I've got 2007 on my pc and I'm trying to set up a timesheet. As I'm to
lazy to keep entering the ":" all the time, i was wondering if someone knew
how to change 1530 to 15:30 etc in the active cell for all cells G5 to I19
on all 5 sheets in my workbook!!!

I think this has something to do with vba or macros and i've never used them
before.

If anyone can help me, I'd be very grateful.

Thanks
Pete

Chip Pearson shows how you can do that he

'Date And Time Entry'
(http://www.cpearson.com/excel/DateTimeEntry.htm)

Hope this helps.

Pete

Pee;294417 Wrote:
Hi, I've got 2007 on my pc and I'm trying to set up a timesheet. As I'm
to
lazy to keep entering the ":" all the time, i was wondering if someone
knew
how to change 1530 to 15:30 etc in the active cell for all cells G5 to
I19
on all 5 sheets in my workbook!!!

I think this has something to do with vba or macros and i've never used
them
before.

If anyone can help me, I'd be very grateful.

Thanks
Pete


--
Pete_UK
------------------------------------------------------------------------
Pete_UK's Profile: http://www.thecodecage.com/forumz/member.php?userid=205
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82294