Changing the format wouldn't change the content from text to number, as
formatting affects only the display, not the contents.

Use =ISNUMBER(G133) and =ISTEXT(G133) to check what you've got. If it looks
like a number but is being regarded as text, you may have spaces or
non-breaking spaces or other non-printing characters in the cell with your
number.
--
David Biddulph

"Ed" wrote in message
...

Excel evaluates this formula as G133 not being a number, which is
confusing because that cell plainly is a number and I even reformatted
the whole column to be numbers, just to be safe. Any thoughts?
...