In My Own Little World, But that’s OK because they know me there!
Posts
271
Excel formatting 2007
Hello Everyone:
I am trying to change this (00h 07m 08.8s) so that the h’s m’s & s’s are like they are like they are a number that is squared or raised to a power? I tried coping it but the format changed.
Thanks
Art
SLEEP: A Totally Inadequate Substation For Caffeine!
i don't know that you can use superscript characters in a cells number format, unless you can find a font that has characters like that, the arial set has the m only, which is a unicode character
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Reply With Quote
Resolved", if the query is solved