The green triangles don't actually say there's an error, just what Excel thinks is an inconsistency.



To convert a 'numerical text' range to numbers:
• input a 1 in an empty cell
• cut the number
• select the range to be modified
• choose Paste > Paste Special > Values > Multiply > OK
Note: you can select a whole column for this, but any empty cells will end up with 0s in them and any cells containing formulae will be converted to their results (ie the formulae will be lost). Text will be unaffected.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,
I think I'm within my rights to call them "errors", given that the Excel developers called this feature "Error Checking" and the green triangle is defined in the Excel helpfile as an "Error Indicator". But I do like the term you've used there: "inconsistency".

Congrats on the promotion to Super Moderator. By the way, are you going to the summit next month?

Cheers,
Colin

MS MVP - Excel

Thanks Colin,

Unless MS cares to send me a big fat cheque to cover return airfares from Australia, I very much doubt I'll be getting to any summit.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]