Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fraction only using Integer Numbers

Status
Not open for further replies.

terzaghi

Programmer
Aug 25, 2003
49
IT
Hi,

I need to whow numbers in excel cells in this format:

Number 3,5 ---> See in Cell: "7/2"
number 2,2 ---> See in cell: "11/2"

i.e. I need to see a fraction done with integer numbers (i.e. the the fraction with the smalles integer numbers that rapresents that decimal number)

does anyone knows how to do that (in Format cell the Fractional format does not work..)

Thanks a lot!
A
 
Ok done.

Format cell "??/??" (never used this format!!)

Bye
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top