Excel thinks I am creating a formulae

TimTDP · #1 07-27-2020, 05:10 AM

If I enter -6.6 into a cell, Excel returns an error message saying that the formulae is incorrect. I am not trying to create a formulae. Just want to enter a negative number!
The cell is format as General. Have tried changing it to Number, but this did not help

How do I correct this?

Excel suggested putting an apostrophe before the number, e.g. '-6.6, but then I cannot reference this cell in a formulae in another cell

Logit · #2 07-27-2020, 08:36 AM

Does this help ?

How to Change How Excel Displays Negative Numbers

Purfleet · #3 07-28-2020, 12:30 PM

i wonder if it is something to do with regional settings? Can you attach an example work book?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word thinks 1 sentence is 2 paragraphs and won't let me delete the extra paragraph symbol	jrasicmark	Word	1	12-05-2014 01:50 AM
Loss of formulae values when mail merging excel to word	MellowMel	Mail Merge	6	05-09-2014 09:08 AM
formulae to combine excel records	H28Sailor	Excel	7	03-31-2013 02:26 PM
Word thinks I'm starting a new paragraph	CTG	Word	1	04-04-2012 12:27 AM
Word thinks my table is a list	felicitator72	Word	1	12-26-2010 04:24 AM