HOW CAN I SHOW Rs.125000 as 1.25 (RS. IN LAKHS)

[S.K.JAIN]

I AM FROM INDIA & I WANT TO SHOW RS. IN LAKHS

i.e. Rs.125000 as 1.25

 

[David Biddulph]

=A1/100000 or =A1/10^5 or =A1/1E5

 

[Jacob Skaria]

Hi Jain

Check out the below link

http://www.dq.winsila.com/tips-tric...show-currency-in-indian-format-and-words.html

If this post helps click Yes