How to prevent rounding when adding fractions

[dereklink]

Hello everyone, below is an example of the problem I am having. When I add using the sum formula, Excel keeps giving me a 1 for an answer. Anyone have a better formula for adding fractions to yield a fraction? Thanks!

[TABLE="width: 134"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD] 1/2[/TD]
[/TR]
[TR]
[TD="align: right"]+[/TD]
[TD] 3/5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1 [/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

See if this works.

Go to Format Cells
-Fraction
-Up to Two Digits

Result should look like example below.

Excel Workbook
	A
1	1/2
2	3/5
3	1 1/10
Sheet

 

[Momentman]

Welcome to the forum

Sticking with Ahoy on this one

 

[dereklink]

Brilliant thanks! I was trying that last night but could not get it to work! It seems to now so I was doing something wrong, thanks!

 

[dereklink]

Momentman, I have them formatted to generate random numbers