Write degrees in a cell and use functions

[rog]

Hello,

This is my problem:

I'm trying to write some cells with temperatures and then get the functions
MAX(), MIN() to give me the minimun and maxim temperatures for a range, but
if I write for instance:

Row D cell format personal: 0.00"°C";-0.00"°C";0.00"°C" Formula:
=MAX(D810) Result: 000ºC

Row F personal cell format: 0 "ºC" Formula: =MAX(F810)
Result: 0 ºC

Row H personal cell format: 0,00 ºC Formula =MAX(H8:H10) Result:
0,00 ºC

Row I general format of cells Formula =MAX(I8:I10) Result: 34
which is wright.

Note all the cells in each row have the same values.

Does anybody know how to introduce the degrees simbols and characters and
still make the functions MAX,MIN, etc.. work?

Note: I've got my excell version in Spanish so I'm translating from it,
please forgive any misstranslation.

Thanks

 

[Bernard Liengme]

This is not what I get when I use the custom format shown in your message. I
get the correct MAX and MIN values
Try typing some number such as 20,30,40 into a range and then do the custom
formatting

If you wish I can send you a sample file (I assume the caps in you email
address are spam-blockers)

best wishes
Bernard

 

[rog]

Thanks I solved the problem, what I did wrong was that instead of typing the
numers such as 34, 35... I was typing in the cell the complete format ie: 35
º C, begginer mistake I guess

Pd: the caps in my address are spam blockers ;-)