View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
TheJoneser TheJoneser is offline
external usenet poster
 
Posts: 5
Default Changing currency from European style to American

I don't have an International tab in the options dialog box. Maybe I don't
have an international version? I'm not sure now. At any rate it is Office
2000 if that helps.

"Gord Dibben" wrote:

You could do this in Regional Settings in Control Panel or in newer versions of
Excel, 2003 for sure, you can set your decimal separators for Excel at
ToolsOptionsInternationalNumber settings.


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 10:02:01 -0700, TheJoneser
wrote:

I have a European version of Office that formats currency as 1.000,00. I
need to change it to the American convention of 1,000.00

Can someone please help me accomplish this. Thank you.