The easy way would be to highlight the column, select Edit, Replace and
enter the $ character in the 'Find What' and click 'Replace All'


and also check that the column is not formatted for 'Currency'


bill gras Wrote:
how do I remove $ caracter from a formula in some cells eg

F
1 0
2 $20000 ($134)
3 $1750
4 1320
5 $2450 ($470)
6 0
7 0
8 2800
9 $2200 ($22)
10 $166
11 $2300 ($23)
12 $155 ($67)
13 $ 4578 ($345)
14 0
and so on
thank you all

bill
--
bill gras


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476117