Hi folks,

I have the following £50...it is defined as a number without me doing
anything. I have $50 ...it is defined as text without me doing anything. I
have 10% sometimes (depending on the pc) it is a number and sometimes text,
similarly 10,000. Now I assume that the £50 is recognised as a number
because of my windows settings...but the rest? Trying to get the $50
recognised as currency is possible....if I delete the original $50, format
the cell as currency, and then re-enter the 50. I would love to know what
deifnes the figure as text or number, and how I can move between the two
without having to delete the figures.

Danny