#1
|
|||
|
|||
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!! |
#2
|
||||
|
||||
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 |
Tags |
negative degree |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to write the degree, minute second format in excel | Jamal NUMAN | Excel | 12 | 07-09-2018 11:44 PM |
Negative total float | loukas | Project | 2 | 11-29-2015 10:38 AM |
Excel VBA to convert number to negative | dakm63 | Excel Programming | 1 | 05-26-2015 10:49 AM |
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 |