Which separator is needed for entering multiple dollar amounts in one currency cell?

Question

Level 1

4 points

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.

Posted on Feb 9, 2023 5:34 PM

Reply

Answer 1

Best reply

Badunit

Level 7

26,542 points

Feb 9, 2023 6:16 PM in response to SeanStussy

If you want the cell to have a numeric value in it, you'll have to stop putting two separate values in it. $100 $100 is not a number, it is text. There is no "separator" that will change that.

If you want it to look like you showed in your screenshot but have it actually work, put Bike and Car in separate rows like you did the other ones and remove the horizontal gridline between the rows. I don't know why you would want to have it look this way but you said don't ask so I won't.

Reply

Answer 2

Ralf-F

Level 4

2,621 points

Feb 10, 2023 3:02 AM in response to SeanStussy

Hi SeanStussy,

Numbers can not display and calculate currency as shown by you.

But if you want to enter multiple amounts you could write it as a formula

B4=100+100

Cell B4 would display $200.00, but as soon as you select the cell you would see that it is the total of 100+100.

Regards Ralf

Reply

Which separator is needed for entering multiple dollar amounts in one currency cell?

Similar questions