fractions in excel
 

i want to imput fractions in excel but i dont want excel to simplify
them is this possible? because im trying to input 2/60 and it changes
it to 1/30...how do i cancel this process???


--
pakipaki
------------------------------------------------------------------------
pakipaki's Profile: http://www.excelforum.com/member.php...o&userid=27381
View this thread: http://www.excelforum.com/showthread...hreadid=469050

First format the cells as text.
************
Anne Troy
www.OfficeArticles.com

"pakipaki" wrote in
message ...

i want to imput fractions in excel but i dont want excel to simplify
them is this possible? because im trying to input 2/60 and it changes
it to 1/30...how do i cancel this process???


--
pakipaki
------------------------------------------------------------------------
pakipaki's Profile:
http://www.excelforum.com/member.php...o&userid=27381
View this thread: http://www.excelforum.com/showthread...hreadid=469050

Assuming the denominator is always 60, use custom format: # ??/60
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pakipaki" wrote in
message ...

i want to imput fractions in excel but i dont want excel to simplify
them is this possible? because im trying to input 2/60 and it changes
it to 1/30...how do i cancel this process???


--
pakipaki
------------------------------------------------------------------------
pakipaki's Profile:
http://www.excelforum.com/member.php...o&userid=27381
View this thread: http://www.excelforum.com/showthread...hreadid=469050