Excel - Entering fractions

Ask a question

Issue


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

Solution


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

Excel - Select all empty rows/cells
Excel - Don't display zero if result is null