Hi,
Why not just format the cells with a different format? What format do you
want in place of currency?
If what you are trying to do is a mass change of formats, you can do that
with the Replace dialog box.
1. Select the range you want to work with.
2. Press Ctrl+H and click Options
3. Remove any entries in the Find what and Replace with boxes
4. Click the top Format button and on the Number tab find the format you
want to replace.
Note there is an option at the bottom of the Find Format dialog box called
Choose Format from Cell, click it and you can "pick up" the format from a
cell.
Come back to the Find and Replace box
3. Click the bottom Format button and pick the desired format.
If this helps, please click the Yes button.