MAX MIN formulas returning value 0.0000, why? Please Help me

[Swulvi]

Hello I have been using the max min formulas for a while but suddenly they have started to return values of 0 regardless of what I do.

I have numbers in a pivot table on a separate sheet like 0.7000 0.8000 0.9000 etc. The spreadsheet is called Data so my formula looks like this =MAX('Data'!D2:D5) or =MIN('Data'!D2:D5) but it returns 0.0000. What am I doing wrong?

If somebody can help me I would really appreciate it.

Kind Regards

Swulvi

[Jonmo1]

If it was just the MIN function returning 0, then that could be explained by an actual 0 appearing in the range..

But if MAX is also returning 0, then the numbers in your range are not really numbers at all.
They're probably 'Numbers Stored As Text'

What does this return
=ISNUMBER('Data'!D2)
And filled down to D5

[Swulvi]

The result is false, I must have corrupted my data on the csv some how, Will have to investigate. Thanks for the quick reply.

[Jonmo1]

You're welcome.

[FDibbins]

I must have corrupted my data on the csv some how

Not necessarily, CSV often pull numbers in as text

[Pete_UK]

A quick way of changing them to numbers:

Highlight the data in column D of the Data sheet.
Click on Data | Text-to-columns
Click Finish on the dialogue box

Done.

Hope this helps.

Pete