CJ
Board Regular
- Joined
- Feb 22, 2002
- Messages
- 77
Hi guys, A nice simple one!!!!
I have imported some data into a spreadsheet
but the time has come across as a number
ie, 1630 instead of 16:30 (to many to do manually - 500+)
Can anyone advise me on a formula or a custom format to insert a colon in the number two places in from the right
CHRIS
I have imported some data into a spreadsheet
but the time has come across as a number
ie, 1630 instead of 16:30 (to many to do manually - 500+)
Can anyone advise me on a formula or a custom format to insert a colon in the number two places in from the right
CHRIS