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?

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?

Format/Cells/Number/Custom

#,

In article ,
"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?

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?