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

[Redleader1]

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?

 

[sky1in5]

in C1 put this formula ="$" & A1 & "." & B1

 

[VoG]

One way

Excel Workbook
	A	B
1	27	65
2	35	42
3	66	34
4	97	15
5	100	23
6	326	79
Sheet1

 

[Redleader1]

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]

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

 

[VoG]

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

 

[Redleader1]

Thanks guys, you're awesome!
Works perfectly!