Hi,
I want to enter data in a cell in the form of paise and get it converted to rupee i.e divide by 100, as soon as I press enter key.E.g:26.94 should show 0.2694.In custom formatting I can multiply by entering * 100 in Type area but cannot divide.How do achieve this ?
I want to enter data in a cell in the form of paise and get it converted to rupee i.e divide by 100, as soon as I press enter key.E.g:26.94 should show 0.2694.In custom formatting I can multiply by entering * 100 in Type area but cannot divide.How do achieve this ?