How do I create a spread sheet w/a numerator/denomenator?
 

I am creating a spread sheet that has different numerators and denomenators
for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3 is
positive) however it is then converted into simpler terms loosing the
denomenator feature.

Such as 2/4 is then changed to 1/2 so I lose the accuracy of the denomenator.

Any ideas of how I can keep the integrity of both the numerator totals and
the denomenator totals?

Hi!

Why not just enter them as text?

'2/3
'2/4

Biff

"Denise" wrote in message
...
I am creating a spread sheet that has different numerators and denomenators
for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3
is
positive) however it is then converted into simpler terms loosing the
denomenator feature.

Such as 2/4 is then changed to 1/2 so I lose the accuracy of the
denomenator.

Any ideas of how I can keep the integrity of both the numerator totals and
the denomenator totals?

Enter numerator in B3 --- 2
Enter denominator in C3 --- 3
D3 =B3&"/"&C3 << Displays 2/3


"Biff" wrote in message
...
Hi!

Why not just enter them as text?

'2/3
'2/4

Biff

"Denise" wrote in message
...
I am creating a spread sheet that has different numerators and
denomenators
for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of
3
is
positive) however it is then converted into simpler terms loosing the
denomenator feature.

Such as 2/4 is then changed to 1/2 so I lose the accuracy of the
denomenator.

Any ideas of how I can keep the integrity of both the numerator totals
and
the denomenator totals?

I need to have the numerators and denom add separately to maintain the total
numbers of both.

"Biff" wrote:

Hi!

Why not just enter them as text?

'2/3
'2/4

Biff

"Denise" wrote in message
...
I am creating a spread sheet that has different numerators and denomenators
for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3
is
positive) however it is then converted into simpler terms loosing the
denomenator feature.

Such as 2/4 is then changed to 1/2 so I lose the accuracy of the
denomenator.

Any ideas of how I can keep the integrity of both the numerator totals and
the denomenator totals?

Thank you, I will try that...

"Jim May" wrote:

Enter numerator in B3 --- 2
Enter denominator in C3 --- 3
D3 =B3&"/"&C3 << Displays 2/3


"Biff" wrote in message
...
Hi!

Why not just enter them as text?

'2/3
'2/4

Biff

"Denise" wrote in message
...
I am creating a spread sheet that has different numerators and
denomenators
for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of
3
is
positive) however it is then converted into simpler terms loosing the
denomenator feature.

Such as 2/4 is then changed to 1/2 so I lose the accuracy of the
denomenator.

Any ideas of how I can keep the integrity of both the numerator totals
and
the denomenator totals?