Stop Automatic Reduction of Fractions
 

Excel 2000/2003- In the company, WIP to Lead-time must be stored in a
worksheet as a fraction- 4/56 for example. When you enter 0 [space] 4/56 and
press enter, Excel reduces the fraction to 1/14. The 4/56 must remain
displayed as 4/56 for this task, and remain a number (so preceeding with a
space or an apostrophe will not work). Anyone know how to stop the automatic
fraction reduction? I don't immediately see any setting.
Thank you. Annie

Whilst there isn't any way per se to do what you are asking, take a look
at http://www.excelforum.com/showthread.php?t=374128. You could
experiment with text instead of numbers and convert it back to numbers
behind the scenes. re. the apostrophe, I prefer to pre-format the
cells as text.

Not the answer you were looking for, but I hope this helps a bit.

Martin


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=374515

Thank you very much for taking time to answer with great suggestions.
Annie


"MartinShort" wrote:


Whilst there isn't any way per se to do what you are asking, take a look
at http://www.excelforum.com/showthread.php?t=374128. You could
experiment with text instead of numbers and convert it back to numbers
behind the scenes. re. the apostrophe, I prefer to pre-format the
cells as text.

Not the answer you were looking for, but I hope this helps a bit.

Martin


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=374515

Hi, check out the following link

http://exceltips.vitalnews.com/Pages..._Reducing.html

"Annie" wrote:

Excel 2000/2003- In the company, WIP to Lead-time must be stored in a
worksheet as a fraction- 4/56 for example. When you enter 0 [space] 4/56 and
press enter, Excel reduces the fraction to 1/14. The 4/56 must remain
displayed as 4/56 for this task, and remain a number (so preceeding with a
space or an apostrophe will not work). Anyone know how to stop the automatic
fraction reduction? I don't immediately see any setting.
Thank you. Annie