Re: How could the number, '102845678' be displayed as '10,28,45,67

[R.VENKATARAMAN]

the modified custom format is
[>=10000000]##\,##\,##\,##0.00;##,##0.00

this gives 122245678 as
12,22,45,678.00



R.VENKATARAMAN <$$$$vram26@vsnl$$$.net$$$> wrote in message news:...
> as I said in the message this is for lakhs(an indian system of
arithmetic).
> you can MODIFY that for crores(the next level to lakh in indian system)
ie.
> 10 crores 28 lakhs 45thousand 678.
>
>
> IanRoy <IanRoy@discussions.microsoft.com> wrote in message
> news:CA9A0478-2838-44A6-AFB9-A266A3A0EAE1@microsoft.com...
> > Hi, All;
> > Curious, I tried this. Custom format [>=100000]##\,##\,##0;##,##0 gave
me
> > 1028,45,678 instead of 10,28,45,678. AutoSum worked on it, though.
Adding
> two
> > of them gave me 2056,91,356. Excel treats these as numbers. It is wise
to
> > avoid provincial assumptions about other peoples' number formats, and
> refrain
> > from blanket negatives about Excel.
> > Regards,
> > Ian.
> >
> > "Oliver Ferns via OfficeKB.com" wrote:
> >
> > > In short, you can't. Why? Because '10,28,45,678'is not a number.
> However,
> > > were you to start the cell entry with an apostrophe "'" then you can
> > > achieve the effect of 10,28,45,678. Excel will not be able to perform
> > > numerical calculations on this cell.
> > >
> > >
> > > Hth,
> > > Oli
> > >
> > > --
> > > Message posted via http://www.officekb.com
> > >
>
>

[Oliver Ferns via OfficeKB.com]

I stand (sit?) corrected. I did try to achieve this through custom formats
but with no joy. It seems I have much to learn!

Thanks
Oli

--
Message posted via http://www.officekb.com