On Jul 21, 1:07*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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?
...- Hide quoted text -

- Show quoted text -

That seems to have been it: there seems to have been a hidden or
invisble space or something that was making the cell read as non-
number. Any ideas on how to input numbers in to the G column and not
have to worry about this?