chrissyboy
New Member
- Joined
- Jan 14, 2004
- Messages
- 2
Hi, New to the board...
I am trying to format a range of cells to show half hourly increments, say 12.00, 12.30, 01.00, 01.30 etc etc..
Trouble is, every time I use the format command from the toolbar, excel adds a date and then increments by 1...??
I have used excel for some years now, and it has always been a case of right click on the cell, format and everything was AOK...this is a clean install of office 2000, running on win 2k pro...can anyone help?
Cheers
I am trying to format a range of cells to show half hourly increments, say 12.00, 12.30, 01.00, 01.30 etc etc..
Trouble is, every time I use the format command from the toolbar, excel adds a date and then increments by 1...??
I have used excel for some years now, and it has always been a case of right click on the cell, format and everything was AOK...this is a clean install of office 2000, running on win 2k pro...can anyone help?
Cheers