Convert decimal to fractions
 

Hello,

Can you please advise on the formula to use...

In Cell D10:D1000 I have decimal numbers...
D10 .5
D11 .75
etc!
In Cell F10:F1000 I want to enter a formula that will convert the decimal
numbers to fractions
F10 1/2
F11 3/4
etc!

Regards,

Eamon

Convert decimal to fractions
 

Format Cells Select Fraction


"Eamon" wrote:

Hello,

Can you please advise on the formula to use...

In Cell D10:D1000 I have decimal numbers...
D10 .5
D11 .75
etc!
In Cell F10:F1000 I want to enter a formula that will convert the decimal
numbers to fractions
F10 1/2
F11 3/4
etc!

Regards,

Eamon

Convert decimal to fractions
 

In F10 put =D10, then Format/ Cell/ Number/ Fraction
--
David Biddulph

"Eamon" wrote in message
...
Hello,

Can you please advise on the formula to use...

In Cell D10:D1000 I have decimal numbers...
D10 .5
D11 .75
etc!
In Cell F10:F1000 I want to enter a formula that will convert the decimal
numbers to fractions
F10 1/2
F11 3/4
etc!

Regards,

Eamon

Convert decimal to fractions
 

Thanks, much appreciated.

Eamon
"David Biddulph" wrote in message
...
In F10 put =D10, then Format/ Cell/ Number/ Fraction
--
David Biddulph

"Eamon" wrote in message
...
Hello,

Can you please advise on the formula to use...

In Cell D10:D1000 I have decimal numbers...
D10 .5
D11 .75
etc!
In Cell F10:F1000 I want to enter a formula that will convert the decimal
numbers to fractions
F10 1/2
F11 3/4
etc!

Regards,

Eamon