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?

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

So swap the comma for a semicolon...

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?

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.)

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