Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If i enter any number "101000" in one cell
I want other cell to show in word "One Lakh one thousand only". Is there any formula for this Please help |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Just check the below link, http://support.microsoft.com/kb/213360 this will give you some idea. Regards, Soundar. "VIVEKMANE" wrote: If i enter any number "101000" in one cell I want other cell to show in word "One Lakh one thousand only". Is there any formula for this Please help |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks it works.........
"Soundar" wrote: Hi, Just check the below link, http://support.microsoft.com/kb/213360 this will give you some idea. Regards, Soundar. "VIVEKMANE" wrote: If i enter any number "101000" in one cell I want other cell to show in word "One Lakh one thousand only". Is there any formula for this Please help |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Sir,
When i enter "100000" it shows "One Hundred Thousand Rupees and No Paise" actually it should show "One Lakh and No Paise" Please help "Soundar" wrote: Hi, Just check the below link, http://support.microsoft.com/kb/213360 this will give you some idea. Regards, Soundar. "VIVEKMANE" wrote: If i enter any number "101000" in one cell I want other cell to show in word "One Lakh one thousand only". Is there any formula for this Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|