Which separator is needed for entering multiple dollar amounts in one currency cell?
Hello All,
I've added more than one total dollar amount into one currency cell (ie. $50, $75) After the additional dollar amount is added, the cell returns to the "Automatic," data format and will not count towards the total SUM of the formula.
(Please see image below.) You can see the total is incorrect and the format of the cell is broken.
What separator is necessary to allow for more than one number in a single currency cell in order to keep the cell in the currency format for SUM formula.
(And please don't ask "Why do you want two numbers in a single cell." I just do👍🏻)
And yes, the SUM total cell has all the number cells attached to the formula.