multiple currencies in excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1328681%22%20slang%3D%22en-US%22%3Emultiple%20currencies%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1328681%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20sheet%20which%20I%20use%20to%20provide%20costing%20in%20various%20currencies%2C%20one%20column%20in%20%E2%82%AC%20and%20the%20next%20one%20is%20in%20%24%20or%20%C2%A3.%3C%2FP%3E%3CP%3EI%20can%20switch%20between%20currencies%2C%20making%20currency%20sign%20(and%20do%20conversion%20based%20on%20exchange%20rates)%20in%20various%20columns%20dependent%20on%20a%20parameter%20in%20the%20overall%20sheet%2C%20but%20does%20anyone%20have%20any%20suggestion%20on%20HOW%20to%20switch%20between%20decimal%20separators%3F%20%E2%82%AC%20uses%20%2C%20and%20%C2%A3%20and%20%24%20have%20.%20as%20decimal%20separators.%3C%2FP%3E%3CP%3Eit%20is%20in%201%20sheet%20in%201%20workbook%2C%20so%20no%20option%20to%20have%201%20workbook%20using%20system%20separator%20and%20other%20one%20using%20excel%20specific%20separators%3C%2FP%3E%3CP%3EI%20would%20prefer%20to%20use%20standard%20formulas%20and%20functions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethx!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1328681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1328887%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20currencies%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1328887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F632593%22%20target%3D%22_blank%22%3E%40Mar10%3C%2FA%3E%26nbsp%3BIf%20I%20were%20you%20I%20would%20not%20worry%20too%20much%20about%20the%20decimal%20separator.%20I'm%20frequently%20involved%20in%20multi-currency%20reporting%20with%20Euros%2C%20Dollars%20and%20Pounds%20and%20just%20use%20the%20period%20for%20all.%20Haven't%20had%20any%20complaints.%20Everybody%20seems%20to%20understand.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329176%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20currencies%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3Ethat%20was%20my%20%222nd%20best%22%20option%20but%20for%20customers%20in%20EU%20this%20does%20seem%20at%20least%20very%20weird...I%20guess%20in%20a%20commercial%20offer%20the%20difference%20between%20a%20thousands%20or%20decimal%20seprator%20is%20more%20relevant%20than%20in%20a%20normal%20report%20where%20idd%20everyone%20adapts...%3C%2FP%3E%3CP%3Ethx%20anyway%20for%20your%20reaction%3C%2FP%3E%3CP%3EMartine%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel sheet which I use to provide costing in various currencies, one column in € and the next one is in $ or £.

I can switch between currencies, making currency sign (and do conversion based on exchange rates) in various columns dependent on a parameter in the overall sheet, but does anyone have any suggestion on HOW to switch between decimal separators? € uses , and £ and $ have . as decimal separators.

it is in 1 sheet in 1 workbook, so no option to have 1 workbook using system separator and other one using excel specific separators

I would prefer to use standard formulas and functions

 

thx!

 

 

2 Replies

@Mar10 If I were you I would not worry too much about the decimal separator. I'm frequently involved in multi-currency reporting with Euros, Dollars and Pounds and just use the period for all. Haven't had any complaints. Everybody seems to understand.

@Riny_van_Eekelenthat was my "2nd best" option but for customers in EU this does seem at least very weird...I guess in a commercial offer the difference between a thousands or decimal seprator is more relevant than in a normal report where idd everyone adapts...

thx anyway for your reaction

Martine