Discussion on:
Message 20 of 22
0
Votes
RE: Prevent Excel from turning fractions into dates
If the value is not used in calculations and is manually entered into Excel, using a single quote (i.e. '1/5) will also do the trick.
Posted by Mark A. Lewis
27th May 2009
