TrainityTrainity
All ideas

Text function

Hello Sir, While using Text function, we go like =text(value),formatcode) and if we want to add ₹ symbol, we add it before the format code. So, if we take an example of no.445000. The syntax would be =text(445000,"₹0.00") and the output would be ₹445000. But what if we want our answer to be ₹4,45,000 ? How we can do this .. Please answer.