Trouble with different currencies

techdunce · 01-05-2009, 04:06 AM

Hello, Im having trouble executing formulae on the same worksheet using different currencies, that is to say, I get a Value error. Am I missing a setting that will allow me to use different currencies? Thanks in advance, Techdunce

**gistek** · 01-05-2009, 06:46 AM

If you're using office 2007, highlight the cells you want to format as a different currency and click on the arrow next to the $ button to select a different symbol.

If the symbol you want isn't there, use the Format Cell command and change the symbol there.

techdunce · 01-05-2009, 09:51 AM

Thanks for the reply Gistek, Im using office 2003. If I make a calculation in, for example, sterling, then I cant make a calculation in any other currency on that worksheet. Thanks again, Techdunce

**gistek** · 01-06-2009, 09:16 AM

In a very old spreadsheet application, you couldn't have any non-numeric symbols in a cell used for calculations. (, and. were permitted)

So I added a column in front of any money columns and entered the $ in that column.

techdunce · 01-06-2009, 10:53 AM

Sorry for the delay in replying. And yes, I can do a calculation without symbols, or all in one currency, and then add in another currency symbol later, just thought I should be able to do it all in one go, thanks again,Techdunce

01-05-2009, 04:06 AM	#1 (permalink)
techdunce Registered User Join Date: Apr 2008 Posts: 27 OS: windows xp pro	Trouble with different currencies Hello, Im having trouble executing formulae on the same worksheet using different currencies, that is to say, I get a Value error. Am I missing a setting that will allow me to use different currencies? Thanks in advance, Techdunce

01-05-2009, 06:46 AM	#2 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,919 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Trouble with different currencies If you're using office 2007, highlight the cells you want to format as a different currency and click on the arrow next to the $ button to select a different symbol. If the symbol you want isn't there, use the Format Cell command and change the symbol there. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team

01-05-2009, 09:51 AM	#3 (permalink)
techdunce Registered User Join Date: Apr 2008 Posts: 27 OS: windows xp pro	Re: Trouble with different currencies Thanks for the reply Gistek, Im using office 2003. If I make a calculation in, for example, sterling, then I cant make a calculation in any other currency on that worksheet. Thanks again, Techdunce

01-06-2009, 09:16 AM	#4 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,919 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Trouble with different currencies In a very old spreadsheet application, you couldn't have any non-numeric symbols in a cell used for calculations. (, and. were permitted) So I added a column in front of any money columns and entered the $ in that column. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team

01-06-2009, 10:53 AM	#5 (permalink)
techdunce Registered User Join Date: Apr 2008 Posts: 27 OS: windows xp pro	Re: Trouble with different currencies Sorry for the delay in replying. And yes, I can do a calculation without symbols, or all in one currency, and then add in another currency symbol later, just thought I should be able to do it all in one go, thanks again,Techdunce