A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Number Format



 
 
Thread Tools Display Modes
  #1  
Old September 10th, 2005, 07:59 AM
harikrish
external usenet poster
 
Posts: n/a
Default Number Format


How to format say 123456789 in the format 12,34,56,789. This particular
number format is being used in India. (grouping of 2 digits rather than
3 excluding the last 3 digits)


--
harikrish
------------------------------------------------------------------------
harikrish's Profile: http://www.excelforum.com/member.php...o&userid=27100
View this thread: http://www.excelforum.com/showthread...hreadid=466476

  #2  
Old September 10th, 2005, 09:48 AM
David McRitchie
external usenet poster
 
Posts: n/a
Default

What version of Excel.
In Excel XP see function BhatText as in Thai Bhat currency. =BAHTTEXT(A37)

If you just have positive numbers you can use as custom format like:

[=10000000]##\,##\,##\,##0.00; [=100000]##\,##\,##0.00;##,##0.00

see http://www.mvps.org/dmcritchie/excel...a.htm#bhattext

Negative and Positive Numbers can be handled with a subroutine or event macro by Norman Harker.
http://google.com/groups?threadm=e0n...GP11.phx .gbl
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"harikrish" wrote in message
...

How to format say 123456789 in the format 12,34,56,789. This particular
number format is being used in India. (grouping of 2 digits rather than
3 excluding the last 3 digits)


--
harikrish
------------------------------------------------------------------------
harikrish's Profile: http://www.excelforum.com/member.php...o&userid=27100
View this thread: http://www.excelforum.com/showthread...hreadid=466476



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Number format for Combobox MBlake General Discussion 1 June 29th, 2005 03:25 AM
Combo Box & Text Box AccessRookie Using Forms 3 April 6th, 2005 11:33 PM
16 digit number wont keep alteration unless format cell to text Croc001 General Discussion 3 March 30th, 2005 09:12 AM
why does currency format change to number format? Cassie General Discussion 3 March 18th, 2005 07:57 PM
Number format problem in CSV files Mervyn Thomas Worksheet Functions 3 January 14th, 2004 06:31 PM


All times are GMT +1. The time now is 09:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.