Forum Discussion

Copper Contributor

Mar 19, 2020

keeping the number of decimals

can somebody tell me how I can make sure that in cel C46 and A52the number of decimals will stay at 2 like in the other cells

MVP

Mar 19, 2020

further to the below post note that I missed to inform you about the separator

="<> werkelijke kosten* "&TEXT(D20*(F45/F43),"#,##0.00")

Please use the above formula, attached is the revised file

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.