Having problem to convert a range to a number format

[GIS2013]

Hi. I'm trying to convert a range (a1:a12 in the sample) to a number format, but the code below does nothing.

Know this tiny green sign appears on a cell when there is an error? It suggested me to convert the cell to a number, but when I tried to record this move in order to check its code, it produced basicallty an empty code.. weird, isn't it?

Please Login or Register  to view this content.

[StephenR]

It appears that your cells are full of leading spaces, so perhaps use the Trim formula and paste values and they should be numbers. Or even Find(" ") and Replace ("").

[GIS2013]

Thanks Stephen. I'll do it if there is no other way, the numberformat option looks so easy but it just doesn't work

[StephenR]

Effectively it's text so formatting it as a number won't make any difference.

[alansidman]

Using your spreadsheet example:

Please Login or Register  to view this content.

[GIS2013]

but if I accept the auto-correction tool's suggestion to "convert to number" suddently (see my code below) the MAX function works..

[GIS2013]

@alansidman, thanks it works