digit separator in excel / retrival of old post
Narasimha
I had earlier made a post to this newsgroup regarding custom formatting for
digits separator & I remember 2 persons had replied. Since I reinstalled my
OS without backing up the messages, I would like to know how to view these
old messages in OE or how to view the newsgroups on the Web (the original
post is probably more than 3 months old)
Thanks in advance
Simha
P.S.
If the old post cannot be viewed or retrieved,
i am reproducing the old post
Excel groups the digits after every 2 digits or every 3 digits & so on
but I want a formatting or a macro which applies the following format
for eg., 100000 has to be displayed as 1,00,000
10000000 has to be displayed as 1,00,00,000
(the idea is the first 3 digits are to be grouped and subsequently for the
next 2 digits)
I know the custom format to display in the above format for a
particular number of digits say for 5 digits or 6 digits but I need a format
which displays the comma's / separates the digits irrespective of the
number of digits present
This facility is available in Win-2000 regional settings though the same
cannot
be used in Excel-2000 installed on the same system.
If somebody can tell me the custom formatting or a macro which can apply the
formatting
it will be of great help
Simha
Norman Harker
This is quite recent and you should be able to re-load the Outlook messages.
However, I recall that one of the posters gave the custom format:
##\,##\,##\,###.00;-##\,##\,##\,###.00
Trouble with this is that it doesn't group beyond the 9th digit (as shown)
and that if there are less than 8 digits you get numbers displayed like:
,98,65,987.56
,,65,876.40
,,,654.64
Howver, it's better than nothing, and does allow you to format numbers in
this style and have them treated as number.
hth
"Narasimha" <sim...@zeenext.com> wrote in message
news:ODp8h4RBBHA.1328@tkmsftngp05...
David McRitchie
Google is a lot easier and generally is faster than searching Outlook Express
even though OE is on your own computer. Since you were the original
poster, finding the postings related to your own is easy, simply place your
email address into the Author field. Just out of habit you can still place
*excel* (with the asterisks) into the newsgroups field.
http://groups.google.com/advanced_group_search
Since you are the original author you can sort OE on the From field.
Had you not be the original author you might ungroup the conversations
and sort on the From field. Since most people use more than one group
you would probably want to use Find and then you have to change the
view to Show All and I don't know of any way to force Find to pop
up with "Show All" automatically. I find FIND in OE not very practical
for searching, unless you know the specific article you need to find.
More information on newsgroups, newsgroup searches
http://www.geocities.com/davemcritchie/excel/xlnews.htm
and using Outlook Express:
http://www.geocities.com/davemcritchie/excel/oe5.htm
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm
Dave Peterson
(He had saved a quoted post from a quoted post ad infinitum):
(But I think it's what you're looking for.)
Here's Tushar's post:
==================
PMFJI.
I may not even have the proper context for this discussion but...
A Tushar Mehta reproduction...
of A Carefully Saved message...
of A Bill Manville post...
>From a Time Long, Long Ago...
but not A Galaxy Far, Far Away...
--- begin reproduction ---
Date: Mon, 20 Mar 2000 08:01:42 GMT
Message-ID: <VA.000005a...@msn.com>
Subject: Re: Indian/Foreign currency
From: Bill Manville <Bill-M...@msn.com>
References: <#C2HYFgk$GA...@cppssbbsa02.microsoft.com>
Newsgroups: microsoft.public.excel.worksheet.functions
In article <#C2HYFgk$GA...@cppssbbsa02.microsoft.com>, Avijit Sen wrote:
> There doesn't seem to be any way to format cell values as Indian Rupees
> (Rs.). The closest thing in Format|Cells are Indonesian Rupees?
>
I read about this recently in Woody's Office Watch (to subscribe send an
email to w...@wopr.com )
17. A BETTER SOLUTION FOUND - INDIAN RUPEES NUMBER FORMAT
In WOW 5.04, I shared a few snippets of VBA code that could
be used to format Indian Rupees and Paise. My thanks to
Rajesh K., of Blue Chip Computers for supplying these
custom number formats. They are far easier to employ than
the VBA code. The formats utilize many of the custom number
options be have been discussing: conditional statements,
text enclosed in quotes, and the backslash.
Rupees with Paise
[>9999999]"Rs."##\,##\,##\,##0.00;[>99999]"Rs."##\,##\,##0.00;"Rs."##,##
0
00
Rupees without Paise
[>9999999]"Rs."##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs."##,##0
Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]"##\,##\,##0.00;"##,##0.00
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
--- end reproduction ---
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
Dave Peterson
ec3...@msn.com
Narasimha
This format was "the" one I was looking for.
Thanks to you and others also who have replied to my post.
Thanks once again
Narasimha
"Dave Peterson" <ec3...@msn.com> wrote in message
news:3B446153...@msn.com...
Narasimha
Found my earlier post
Thanks a lot
Narasimha
"David McRitchie" <dmcri...@msn.com> wrote in message
news:#2SD7aUBBHA.1280@tkmsftngp03...
Tushar Mehta
the Internet abetted by the unfettered exchange of information...
I wonder if the pioneers behind the concepts of the Internet and the
Usenet newsgroups even *imagined* what they were making possible!
Solution to formatting of Indian numbering system from
Rajesh K., of Blue Chip Computers
|--> Distributed by Woody's Watch Jan. 2000
|--> Posted by Bill Manville in response to someone Mar. 2000
|--> Snagged and saved by me because the problem was intriguing
|--> Found and used as a response to someone Jul. 2001
|--> Seen and rerouted by Dave Peterson a few days later
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
In <3B446153...@msn.com>, Dave Peterson <ec3...@msn.com> wrote
J.E. McGimpsey
|-->used as an example of meme propagation by Tushar today
Having been using Usenet for approximately 2/3 of its existence, I'm
positive that the designers didn't imagine NG's as they are today -
memory and bandwidth were infinitesimal by comparison with today, and
constraints of that magnitude tend to limit most engineers' horizons
(with occasional exceptions). From
http://www.vrx.net/usenet/history/rename.html :
> "Those who mourn for 'USENET like it was' should remember
> the original design estimates of maximum traffic volume:
>
> 2 articles/day"
>
> -Steven Bellovin
In article <MPG.15ae7470...@msnews.microsoft.com>,
Tushar Mehta <ng_p...@bigfoot.com> wrote:
> Am I the only one struck by the power unleashed by the proliferation of
> the Internet abetted by the unfettered exchange of information...
>
> I wonder if the pioneers behind the concepts of the Internet and the
> Usenet newsgroups even *imagined* what they were making possible!
>
> Solution to formatting of Indian numbering system from
> Rajesh K., of Blue Chip Computers
> |--> Distributed by Woody's Watch Jan. 2000
> |--> Posted by Bill Manville in response to someone Mar. 2000
> |--> Snagged and saved by me because the problem was intriguing
> |--> Found and used as a response to someone Jul. 2001
> |--> Seen and rerouted by Dave Peterson a few days later
>
--
J.E. McGimpsey ar...@zptvzcfrl.pbz
ROT13 encoding, decode for real mail
David McRitchie
postive numbers up to 99,99,99,999.99 i.e. 999,999,999.99
Negative numbers will appear as (999,999,999.99) which is
still arithmetically correct.
I knew there was a solution in 1997 just couldn't find it and still can't..
There is a typo in the last formula, remove the double quotes left in after
removing the "Rs." constant. Yes the typo was in all the quoted material.
"Tushar Mehta" <ng_p...@bigfoot.com> ...
> > Rupees with Paise
> >
> > [>9999999]"Rs."##\,##\,##\,##0.00;[>99999]"Rs."##\,##\,##0.00;"Rs."##,##
> > 000
> >
> > Rupees without Paise
> > [>9999999]"Rs."##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs."##,##0
> >
> > Rupees without Rs. notation
> > [>9999999]##\,##\,##\,##0.00;[>99999]"##\,##\,##0.00;"##,##0.00
corrected w/o double quotes:
> > [>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00
actually wouldn't this be more correct
> > [>9999999.99]##\,##\,##\,##0.00;[>99999.99]##\,##\,##0.00;##,##0.00