M MAH New Member May 3, 2018 #1 I want to change my variance I have to be rounded to nearest thousand or million and also show + or -. For example This Year Last Year Variance What I want displayed 10000 200000 10000 -10K 40000 60000 20000 +20K
I want to change my variance I have to be rounded to nearest thousand or million and also show + or -. For example This Year Last Year Variance What I want displayed 10000 200000 10000 -10K 40000 60000 20000 +20K
N NARAYANK991 Excel Ninja May 3, 2018 #2 Hi , See the attached file. If you do not want the decimal point , remove it from the custom cell format. Narayan Attachments Data.xlsx 9.1 KB · Views: 5
Hi , See the attached file. If you do not want the decimal point , remove it from the custom cell format. Narayan
