V
via135
using custom format how can i format the number 12345678.91 as
1,23,45,678.91? i think it would be a simplest one!
-via135
1,23,45,678.91? i think it would be a simplest one!
-via135
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
From a Google search here is a reply by David Richie to the same question in
January 2005
If you have Excel 2002 or later look up bhattext in help.
Otherwise the following format might help you
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
(This format separates groups for India/Thailand, format valid for
positive numbers up to 99,99,99,999.99 or 999,999,999.99)
in Excel XP see function BhatText as in Thai Bhat currency.
=BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] ==an alternative may
be to use Control Panel, Regional Settings, Numbers,
digit grouping.
see:
http://www.google.ca/groups?q=indian+currency+group:*excel*&hl=en&lr=...
January 2005
If you have Excel 2002 or later look up bhattext in help.
Otherwise the following format might help you
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
(This format separates groups for India/Thailand, format valid for
positive numbers up to 99,99,99,999.99 or 999,999,999.99)
in Excel XP see function BhatText as in Thai Bhat currency.
=BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] ==an alternative may
be to use Control Panel, Regional Settings, Numbers,
digit grouping.
see:
http://www.google.ca/groups?q=indian+currency+group:*excel*&hl=en&lr=...
V
via135
thks bernard!
its quite ok!!
i didn't notice Richie's reply on the subject!
-via135
its quite ok!!
i didn't notice Richie's reply on the subject!
-via135
Bernard said:From a Google search here is a reply by David Richie to the same
question in
January 2005
If you have Excel 2002 or later look up bhattext in help.
Otherwise the following format might help you
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
(This format separates groups for India/Thailand, format valid for
positive numbers up to 99,99,99,999.99 or 999,999,999.99)
in Excel XP see function BhatText as in Thai Bhat currency.
=BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] ==an alternative
may
be to use Control Panel, Regional Settings, Numbers,
digit grouping.
see:
http://www.google.ca/groups?q=indian+currency+group:*excel*&hl=en&lr=...
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
in
message news:[email protected]...using custom format how can i format the number 12345678.91 as
1,23,45,678.91? i think it would be a simplest one!
-via135
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26725
View this thread: http://www.excelforum.com/showthread.php?threadid=498408