Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2020, 05:10 AM
TimTDP TimTDP is offline Excel thinks I am creating a formulae Windows 7 64bit Excel thinks I am creating a formulae Office 2010 32bit
Advanced Beginner
Excel thinks I am creating a formulae
 
Join Date: Apr 2012
Posts: 41
TimTDP is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-27-2020, 08:36 AM
Logit Logit is offline Excel thinks I am creating a formulae Windows 10 Excel thinks I am creating a formulae Office 2007
Expert
 
Join Date: Jan 2017
Posts: 330
Logit will become famous soon enough
Default

Does this help ?

How to Change How Excel Displays Negative Numbers
Reply With Quote
  #3  
Old 07-28-2020, 12:30 PM
Purfleet Purfleet is offline Excel thinks I am creating a formulae Windows 10 Excel thinks I am creating a formulae Office 2019
Advanced Beginner
 
Join Date: Jun 2020
Posts: 47
Purfleet is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel thinks I am creating a formulae 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
Excel thinks I am creating a formulae formulae to combine excel records H28Sailor Excel 7 03-31-2013 02:26 PM
Excel thinks I am creating a formulae Word thinks I'm starting a new paragraph CTG Word 1 04-04-2012 12:27 AM
Excel thinks I am creating a formulae Word thinks my table is a list felicitator72 Word 1 12-26-2010 04:24 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft