On Wed, 6 Jul 2005 17:04:03 -0700, MM_BAM < XXXX@XXXXX.COM >
The format of a cell does not directly give you information as to whether the
contents are TEXT or NUMBER. One way to detect that is with the
If the data is coming via the WEB, the most common cause for the behavior you
describe is the addition of a non-break space at the end of the number. This
is CHAR(160). To "clean up" the data, you could try this formula:
If that doesn't do it, by using the MID function you can step through the
contents of the cell one character at a time, and see exactly what you have.
For example, with A1 containing the number 23, followed by the no-break space,
do the following:
Select B1 & C1 and copy/drag down to row 4.
You should see the following:
A similar strategy will let you analyze what's going on with your cells.