Hi again - could not find out how to post a new topic and searching was too vague
I am trying to do a custom number format that has zero decimal places if the number is >100 and <-100 - so between -100 and 100 i want to display 2 decimal places otherwise zero
I got the first part fro Chandoo and following the logic tried this - but it did not work - any help once again much appreciated
[<100]_(#,##0.00_);[<-100]_(#,##0);_(#,##0) the first condition works - any positive number>100 has 1DP - the problem is with negative
Bookmarks