Autoremoving $ sign

Z

zomboolio

I am using Excel 2000, and have data that includes cells with 'text',
'currency' and 'numbers'. The text and numbers are no problem, but the
'currency' is prefixed with '$'. The source data cannot be changed
before it reaches me, but my formulae will not work with the '$' sign
preceeding the currency amounts. I have tried removing it by formatting
the cells to show no currency sign, but when I then paste the data, it
appears. The only two things I can think of is that it is something to
do with the '$' sign meaning something within formulae or because I am
in the UK and my PC is set for UK currency, time etc, and that is why
it wont allow me to change it.

Any help is appreciated.

Thanks
 
C

cornishbloke

If you wish to remove all the $ symbols on the sheet then you could use
the replace function (Ctrl+H) to replace all '$'s with nothing, thus
removing them.
 
M

Max

The $prefixed cells might be text format

Try wrapping with VALUE()?

e.g. if the source cells are in col A, row2 down

instead of : =VLOOKUP(A2,Table,2,TRUE)

use: =VLOOKUP(VALUE(A2),Table,2,TRUE)
 
Top