Excel - Entering fractions

October 2016


I'm trying to enter a fraction in a cell ,but Excel is automatically converting it as a date.


Simply add a 0 (followed by a space) before entering the fraction:

Related :

This document entitled « Excel - Entering fractions » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.