Hi
I am trying to alter a column which is formatted in "General" I.e Just Numbers (1, 2, 1.5 etc)
I am trying to get the values to read as HH:MM format so 1.5 becomes 01:30, 2 becomes 02:00 etc.
The code I have used in the past is as follows:
For some reason on this occassion it is coming up with an error on the line Cell.Value = Cell.Value / 24 and I really can't see why.
I have used this piece of code countless times before with no problems but on this occassion it simply won't work.
Has anybody got any ideas?
Thanks In Advance
Mark
Bookmarks