I have MS excel 2003 on XP Sp 2.
I have regional settings set to show the digit group
like 00,00,000.00 in currekcy as well as in numbers.
I have set teh options in excel to use system
separators.
still, when I format ny digits as numbers or currency it
follows only 000,000.00
I want thousnad seperator only once, later digit to be
grouped in couples.
Any clue?
PLease send replies to "xxxxxxxxxx",too. thanks.
Amended - E-mail address deleted to stop OP getting spam mail
Last edited by VBA Noob; 11-12-2007 at 02:44 AM.
Hi,
May be this Add-In will help?
http://www.dq.winsila.com/tips-trick...and-words.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Try Format > Cells > Number > Custom ##,##,##0.00
That doesn't seem to work, Excel changes it to #,###,##0.00Originally Posted by shg
Last edited by oldchippy; 11-15-2007 at 08:22 AM.
Indeed it does.That doesn't seem to work, Excel changes it to #,###,##0.00
This worked for me:
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
Hi shg,
I got that one to work OK, thanks for the full format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks