| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stop my speadsheet from creating an automatic backup copy | Excel Discussion (Misc queries) | |||
| find automatic page breaks | Excel Worksheet Functions | |||
| How do i stop automatic decimals after number ex 5280.? | Excel Discussion (Misc queries) | |||
| How do I stop automatic hyperlinks? | Excel Discussion (Misc queries) | |||
| How do I stop automatic page breaks in excel | Excel Worksheet Functions | |||
Threaded Mode
