#1
|
|||
|
|||
Excel thinks I am creating a formulae
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 |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
i wonder if it is something to do with regional settings? Can you attach an example work book?
|
Thread Tools | |
Display Modes | |
|
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 |