I was having similar difficulty whenever I wanted to import payments from an internet website via copy and paste, the dollars cell data turned up as text. I scoured this forum site and found a few hints leading to this solution. This actually is a combination of 2 formulas.

1. to convert the imported dollar figure text into text still, this formula is

=RIGHT(F4;LEN(F4)-2)

where F4 is the cell to be converted. The -2 refers to the 2 digits '$ and the space' we want to rid of.

2. convert the above data into number using the value formula

=VALUE(G4)

where G4 is the calculated cell of formula 1 above. Now confirm conversion to numeric value by \View \Value Highlighting and there it is - blue.

3. A shortcut combination of the 2 above is

=VALUE(RIGHT(F4;LEN(F4)-2))

where F4 is the cell to be converted.

ps. Following success on this last formula in the cell e.g. I4 - the same formula can be used in the series (highlight I4 down I5:I10 for example) to apply for the rest of imported data using the \Edit \Fill \Down

Please give me feedback if this is repetition or already dealt with or if new and helpful to you.

Thanks