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