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

Redleader1

New Member
Joined
Mar 6, 2013
Messages
5
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?
 

Some videos you may like

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
Joined
Dec 24, 2012
Messages
396
in C1 put this formula ="$" & A1 & "." & B1
 
Last edited:

Redleader1

New Member
Joined
Mar 6, 2013
Messages
5
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
Joined
Feb 1, 2003
Messages
17,832
Hi,
You can use a numberformat "00"
kind regards,
Erik
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Select the cents column, press CTRL + 1, click Custom, in the box type 00 then click OK.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,978
Messages
5,447,670
Members
405,462
Latest member
est1989

This Week's Hot Topics

Top