Thread: Changing currency from European style to American
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Changing currency from European style to American
=SUBSTITUTE(SUBSTITUTE(A1,".",""),",",".")+0

Format cells to your desired style


"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.
Reply With QuoteReply With Quote