H
Harold Good
Hi,
From all my reading, I've determined what I want to do is not possible with
Excel 2003, at least without using VBA.
I have a spreadsheet that uses 2 currencies. One is always US $, the second
can vary, depending on what country the finance report comes to me from.
For this second currency, is there any way I can have certain cells take on,
e.g the '£' currency format when a value or format is entered in another
single cell?
For example, I'd like numbers in column B to display the '£' currency
format when a value or format is entered in A1. Or if the report comes from
Kenya, to have "KSH" preceed any numbers in column B, based on them entering
KSH in A1.
It seems a shame that Excel doesn't allow Numbers under their conditional
formating where I can enter a formula. Why not?
I've tinkered with Custom Number format, but can't make anything work.
Unless someone has a great solution, I shall have to settle for having no
currency format at all in Col B. Since these cells are sprinkled thru out
the spreadsheet, it'd be too much off a pain to have them select them and
change the format to their country each quarter.
Thanks for any thoughts you may have,
Harold
From all my reading, I've determined what I want to do is not possible with
Excel 2003, at least without using VBA.
I have a spreadsheet that uses 2 currencies. One is always US $, the second
can vary, depending on what country the finance report comes to me from.
For this second currency, is there any way I can have certain cells take on,
e.g the '£' currency format when a value or format is entered in another
single cell?
For example, I'd like numbers in column B to display the '£' currency
format when a value or format is entered in A1. Or if the report comes from
Kenya, to have "KSH" preceed any numbers in column B, based on them entering
KSH in A1.
It seems a shame that Excel doesn't allow Numbers under their conditional
formating where I can enter a formula. Why not?
I've tinkered with Custom Number format, but can't make anything work.
Unless someone has a great solution, I shall have to settle for having no
currency format at all in Col B. Since these cells are sprinkled thru out
the spreadsheet, it'd be too much off a pain to have them select them and
change the format to their country each quarter.
Thanks for any thoughts you may have,
Harold