Go Back   Cyber Tech Help Support Forums > Software > Applications

Notices

Reply
 
Topic Tools
  #1  
Old March 11th, 2017, 03:16 PM
keith.evans's Avatar
keith.evans keith.evans is offline
CTH Subscriber
 
Join Date: Dec 2003
O/S: Windows 10 Home
Location: Anglesey, N. Wales.
Age: 62
Posts: 599
Zero Formats

Hi,

Why is it in some circumstances I get a positive zero and others a negative zero?

This has been doing my head in for a little while now!!
Attached Images
File Type: png ExcelZeros.PNG (3.0 KB, 4 views)
Reply With Quote


  #2  
Old March 12th, 2017, 08:59 AM
smurfy's Avatar
smurfy smurfy is offline
Cyber Tech Help Moderator
 
Join Date: Sep 2000
O/S: Linux
Location: Christchurch New Zealand
Posts: 9,448
Rounding? Display format to 2 decimal places, calculation goes to many more decimal places, and at some point, it will show as less than 0?
Reply With Quote
  #3  
Old March 12th, 2017, 01:22 PM
keith.evans's Avatar
keith.evans keith.evans is offline
CTH Subscriber
 
Join Date: Dec 2003
O/S: Windows 10 Home
Location: Anglesey, N. Wales.
Age: 62
Posts: 599
Hi smurfy. What I'm trying to achieve is for the text to turn red when it is no longer in credit or 'in the black'. I have achieved this in many formatted cells but the odd 1 or 2 don't display as I thought they should.

The format (I have just remembered I had) I use to fit the bill is attached along with the errant cell and same format.

I know I can set a format to round up/down and display a minus symbol but not to achieve the red text at the same time.
Attached Images
File Type: png Format01.PNG (16.9 KB, 3 views)
File Type: png Format02.PNG (16.0 KB, 3 views)
Reply With Quote
Reply

Bookmarks

Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT +1. The time now is 05:15 AM.