Converting General format in to HH:MM format

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:

Please Login or Register  to view this content.

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

The thing is it is formatted as general (well, when I right click on it and go in to Format Cells it shows as General under the Number Tab).

Any ideas? I really can't see where it is going wrong.

That seems to work fine.

So was the problem caused by the fact that the first cell (i.e the heading) wasn't numeric? Something so simple??

How annoying!

Thanks (again!) for your help, really appreciate it.

I'm going home to have a cry now!