Formulas Not Accepted

BlueRhinos

Board Regular
Joined
Aug 31, 2007
Messages
83
I have a file with a worksheet that doesn't accept formulas even that begin with an equal sign and have accurate syntax. Rather than return a value, the cell contains the formula syntax with the equal sign. This problem can be isolated to 1 worksheet in the file. Any ideas what causes this and how it can be fixed?
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

nigelk

Well-known Member
Joined
Aug 30, 2008
Messages
535
The cells are probably formatted as 'text' .Try 'General'

Nigel.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,727
Messages
5,524,478
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top