Autoremoving $ sign

  • Thread starter Thread starter zomboolio
  • Start date Start date
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
 
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.
 
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)
 
Back
Top