|
|
#1
07-27-2020, 05:10 AM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode