Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2016, 10:43 AM
JUSTIN CMM JUSTIN CMM is offline How does Excel put values on negative degree(s)? Windows 7 64bit How does Excel put values on negative degree(s)? Office 2010 64bit
Novice
How does Excel put values on negative degree(s)?
 
Join Date: Jan 2016
Posts: 1
JUSTIN CMM is on a distinguished road
Cool How does Excel put values on negative degree(s)?


(Normal.jpg) is what my normal data sheet will look like. I am conditionally formatting the values to be black when they are in between the upper and lower tolerances listed.

The problem arises when I try to conditionally format a value in degree(s). I calculate the actual degree from nominal degree, so I will occasionally have a negative degree (and my lower tolerance is a negative degree). It appears Excel thinks negative 1 degree is larger than zero degree. Excel puts the -1:30:00 above the 1:30:00 when I sort largest to smallest. (abnormal.jpg)

Any advice would be appreciated; and please go easy on me, its my first time!!
Attached Images
File Type: jpg normal.jpg (175.9 KB, 11 views)
File Type: jpg abnormal.jpg (200.1 KB, 12 views)
Reply With Quote
  #2  
Old 01-14-2016, 12:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now How does Excel put values on negative degree(s)? Windows 7 64bit How does Excel put values on negative degree(s)? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome

perhaps post a sample sheet. I suspect you have text looking like numbers, but without seeing the real sheet, I'm not quite sure
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
negative degree

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How does Excel put values on negative degree(s)? How to write the degree, minute second format in excel Jamal NUMAN Excel 12 07-09-2018 11:44 PM
How does Excel put values on negative degree(s)? Negative total float loukas Project 2 11-29-2015 10:38 AM
How does Excel put values on negative degree(s)? Excel VBA to convert number to negative dakm63 Excel Programming 1 05-26-2015 10:49 AM
How does Excel put values on negative degree(s)? How to obtain the inverse tan of a value in degree/minute second? Jamal NUMAN Excel 3 07-27-2013 10:18 AM
Custom formatting to make negative numbers show w/o negative sign on charts todor PowerPoint 3 01-16-2013 03:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:55 AM.


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