One way
Highlight cells. Formatcellscustomint the type box enter #,
HTH
ray

"rach1827" wrote:

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?