Anybody know how to caluculate these format
AED 44,00@0%[AED0.00]+1,00@0%]AED0.00] in MS Excel. Unless I enjoy to delete respectively and every above to return with answer is 4500. Is within any method to divide this format. Urgent. Please comfort me. There are lot of Numerical info I hold to affix. But immediately I am doing similar to delete the rest and tag on. It will steal more time. Please support.
Answers: 1. lay emphasis on the undamaged lot of cell near that characteristics of formula
2. ctrl-h and contained by the 1st box put @0%[AED0.00]
3. take off the 2nd box blank, after click replace all
all the formulas will be rid of @0%[AED0.00]
Hope this minister to.