# Create a total from 2 columns that each hold either a dollar or cents value

##### New Member
I have one dollar column with several entries and one cents column with 2 decimal points to the right with several entries.
such as:
27 65
35 42
66 34
97 15
100 23
______
326 79
______
If these columns are totaled in the row below it will come to \$325 and 179c in the separate columns. I want a more logical outcome.

Preferably I want to maintain the separate dollar and cents cells in the row below to display 326 79 as demonstrated. Adding a \$ symbol to the 326 would also be good but not critical.

Alternatively if that is too complicated then: one single cell for both \$+cents (\$329.79) if separated by a decimal point.

Will anyone accept this challenge and show me the answer?

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### sky1in5

##### Active Member
in C1 put this formula ="\$" & A1 & "." & B1

Last edited:

#### VoG

One way

Excel Workbook
AB
12765
23542
36634
49715
510023
6
326
79
Sheet1

##### New Member
That's was great, well done. It worked perfectly! What a champ!

In the case there is only one digit in the cents column such as "9" (9 cents) is there anyway to have that show as "09" rather than "9"?

#### erik.van.geit

##### MrExcel MVP
Hi,
You can use a numberformat "00"
kind regards,
Erik

#### VoG

##### Legend
Select the cents column, press CTRL + 1, click Custom, in the box type 00 then click OK.

##### New Member
Thanks guys, you're awesome!
Works perfectly!