Excel - Entering fractions
April 2018
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:
Related
- Excel - Entering fractions
- Excel - Enter current time in a cell by clicking it » How-To - Excel
- Excel - Enter text in bold for a particular cell » How-To - Excel
- Excel - Enter URLs in the text format » How-To - Excel
- Excel - Change the default action assigned to the Enter key » How-To - Excel
- Current time by clicking comm button in excel » Forum - Excel