ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Different currencies (https://www.excelbanter.com/excel-discussion-misc-queries/135349-different-currencies.html)

jodleren

Different currencies
 
Hi

I have used the currency formatting, but how do I have more than one
currency?

Or, say, I have 4 hours (hrs) of 100 EUR? How do I get a suffix such
as hrs ?
Eg. =sum() hrs ?

BR
Sonnich


David Biddulph[_2_]

Different currencies
 
Custom format: General&" hrs"
(but of course the officicial abbreviation is h, not hrs)
--
David Biddulph

"jodleren" wrote in message
ups.com...
Hi

I have used the currency formatting, but how do I have more than one
currency?

Or, say, I have 4 hours (hrs) of 100 EUR? How do I get a suffix such
as hrs ?
Eg. =sum() hrs ?

BR
Sonnich





All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com