Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

format number as currency based on next cell content

Hello,

I have a table with two columns: Column A = numbers Column B = currency codes (i.e. USD, JPY, EUR, etc...)

example

how can I have cells on column A to automatically format as the correct currency based on the code column B on the same row?

format number as currency based on next cell content

Hello,

I have a table with two columns: Column A = numbers Column B = currency codes (i.e. USD, JPY, EUR, etc...)

exampleexample: https://drive.google.com/open?id=1tvm1mOgys0AYPkXaCN1xCUzyHu3_Vtil ^ (screenshot)

how can I have cells on column A to automatically format as the correct currency based on the code column B on the same row?