Identifying numbers formatted as text or apostraphe

  • Thread starter Thread starter jas0n
  • Start date Start date
J

jas0n

Using Excel 2000 ive a spreadsheet with the wrong end total.

Looking at it, everything appears ok apart from the end total which is
wrong. The cell that the autosum didnt count is not formatted as text or
have an apostraphe in front of the number but excel is not counting this
number.

I opened the spreadsheet in excel 2003 and its the same but Excel 2003
identifies the cell as a problem (green tag put in the corner of the
cell) as being formatted as text or has an apostraphe - it is formatted
as number and does not have an apostraphe.

Excel 2003 repairs it just fine, its just how is it possible to tell on
other spreadsheets if this is the case whilst using excel 2000?
 
Using Excel 2000 ive a spreadsheet with the wrong end total.

Looking at it, everything appears ok apart from the end total which is
wrong. The cell that the autosum didnt count is not formatted as text or
have an apostraphe in front of the number but excel is not counting this
number.

I opened the spreadsheet in excel 2003 and its the same but Excel 2003
identifies the cell as a problem (green tag put in the corner of the
cell) as being formatted as text or has an apostraphe - it is formatted
as number and does not have an apostraphe.

Excel 2003 repairs it just fine, its just how is it possible to tell on
other spreadsheets if this is the case whilst using excel 2000?
Click to expand...

Ok, sorry - found the reason ....

Basically if a number is entered into a cell that is currently formatted
as text and then copied elsewhere it is still stored as text, even if
the format of the cell is chnaged to number format, you have to re-enter
the number in the cell for it change.
 
Hi
One solution is to copy a blank unused cell. Select your range of 'numbers'
and then Edit|Paste Special|Add.
This will make Excel add a zero to each 'number' and make the text entries
into numbers.
Hope this helps.
 
Hi
One solution is to copy a blank unused cell. Select your range of 'numbers'
and then Edit|Paste Special|Add.
This will make Excel add a zero to each 'number' and make the text entries
into numbers.
Hope this helps.
Click to expand...

Yes, cheers .... I copied them across to the next column using cell * 1
and this worked for the text numbers too.
 
Back
Top