Type 1000 in any blank cell. Copy the cell. Select all your currency and hit
Edit--Paste special, Divide.
*******************
~Anne Troy

www.OfficeArticles.com


"rach1827" wrote in message
...
I need to change all of the currency on my spreadsheet from $5000 to just
display 5. Is there any function or format that I can apply to my
spreadsheet to change all of the currency numbers at one time without
having
to go and re-type all of the numbers?