how to change currency

C

cesar_CARRANZA

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When i installed my excel i put spanish and now when i put the currency sign it puts it at the end of the number (like in spain) and not in mexico where i live or the US how can i change it to Us currency without having to format the page or the cells every time?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When i installed my excel i put spanish and now when i put the currency sign
it puts it at the end of the number (like in spain) and not in mexico where i
live or the US how can i change it to Us currency without having to format
the page or the cells every time?

XL picks up currency formats from the System Preferences (International
Pane). Set the format the way you want, then close and restart XL.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top