Practical Microsoft Office, Excel and Outlook help for everyday work
Category archive

Microsoft Excel

Excel formula keeps changing to text: fix it today
Microsoft Excel

Excel formula keeps changing to text: fix it today

Excel keeps changing formulas to text when the cell is formatted as Text, the entry starts with an apostrophe, or paste adds spaces. Fix the format, then re-enter the formula.