Excel Custom Formats 1

[LeighAnne]

Is there any way I can create a custom format so that my cell is always in degrees celsius ?

 

[xlhelp]

I take it you know how to custom format, so just the typed keys are inluded here

type ### then hold the ALT key and on your keypad enter 0176 then type "C"

 

[VulcanJedi]

you can have the two columns F and C and then you convert the F -> C w/
= (5/9)*(A1-32) (for each row, autofill)
then you could hide the prvious columns or blow it out but copy/paste value only.

you could write code to convert:

sub convertDegrees()

for x= 1 to numCells
cells(2,x) = (5/9)*(cells(1, x) -32)
next x

end sub Tranpkp
************************************
- Let me know if this helped/worked!

 

[LeighAnne]

I've tried the solution suggested by xlhelp. I get the 'c' but not the degree sign. I'm using Excel 97.

 

[xlhelp]

Hi, LeighAnne.

I hope you are using the keypad and not the numbers in top row and is your numlock on?

 

[LeighAnne]

Thanks for all your help, it worked ! I was using the numbers on the top row.

Thanks again,

Leigh-Anne