[JezLisle]

Not sure if I'm having one of those days already but, I want to find out to show the Max number between a set of different cells.

I have a report which show different information. I want to take certain cells and find out what the max number would be...

An example of where they are set out is

C12
F12
I12
C24
F24
C36
F36

I thought =MAX(C12,F12 and so on would work but I end up with error

Where I gone wrong?

[Wim Venema]

I think the format should be =MAX(C12;F12...

So swap the comma for a semicolon...

[JezLisle]

I have the problem where that these numbers are imported via code from SQL Server. They are showing as Text when being imported, how can they be changed to number?

[weejas]

The operator for joining arguments in Excel is the comma.

If your values are coming through as text, use the VALUE() function to turn them back into digits. (What I tend to do in this situation is mark then end of the column next to the data range, and then create a formula at the top to do what I need. In this case, it would be =VALUE([CellReference]). Then I copy that formula down to the mark, copy the formula range and paste values over the source column.)

[shades]

Either that, or multiply every cell by 1, which converts them to numbers.