Format cell's currency [Closed]

Report

NewB - Oct 7, 2016 at 09:44 PM

Hello,
I am working with a drop down list that includes 7 or 8 account numbers to choose from through data validation. Various bills are paid from each account and in different currencies. Is there a way to format a column so that when I select a U.S.A. bank account in cell A1 and enter a number X in B1 that it will automatically become $X in cell B1? If a certain UK bank account were selected in A1 and X was entered, to automatically become €X? Thanks everyone.

Format cell's currency
Format cell with text and number - How-To - Excel
Clear format cell excel - How-To - Excel
Formatting cell ✓ - Forum - Excel
Formatting cells based on certain criteria ✓ - Forum - Excel
Formatting cells ✓ - Forum - Excel

Format cell's currency [Closed]

Your reply

Subscribe To Our Newsletter!