Hi,
20 digits is too much for XL, which I think only handles 16 digits accurately.
If you really need accuracy to that degree, you'll have to go elsewhere, or
start splitting the number over 2 cells, which makes the maths quite complex.
If you Google "Big numbers in Excel" you'll see lots of questions, and a few
answers as well.
Regards - Dave.
> Date: Mon, 13 Sep 2010 17:41:19 +0530
> Subject: Re: FW: $$Excel-Macros$$ Entering Data in Excel
> From: vijumob...@gmail.com
> To: excel-macros@googlegroups.com
>
> You all might have see that even when i format the cell/column as
> number, it dont show me the exact number i do enter there.
> Vijay
>
> On Mon, Sep 13, 2010 at 11:35 AM, SUMIT VYAS wrote:
> > Dear,
> >
> > Right Click Cell
> > Format
> > Number Tab
> > Select Number
> > decimal place is 0
> >
> > ok
> >
> > Regards
> >
> > Sumit Vyas
> > +919755549483
> >
> >
> >
> > On Sat, Sep 11, 2010 at 8:00 PM, Saurabh Patel
> > wrote:
> >>
> >> Change the cell format to "Number" by right clicking on cell.
> >>
> >> Regards,
> >> Saurabh Patel
> >>
> >> -Original Message-
> >> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> >> On Behalf Of viju mobile
> >> Sent: Saturday, September 11, 2010 5:39 PM
> >> To: excel-macros@googlegroups.com
> >> Subject: $$Excel-Macros$$ Entering Data in Excel
> >>
> >> Hi All,
> >> I am trying to input 20 digit number in a column. But it does not
> >> enter it correctly.
> >> Please guide me.
> >> Regards,
> >> Vijay
> >>
> >> --
> >>
> >>
> >> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 7000 subscribers worldwide and receive many nice notes about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >>
> >>
> >>
> >>
> >> DISCLAIMER:The information contained in this electronic message and in any
> >> attachments to this message is
> >> confidential, legally privileged and intended only for the
> >> person or entity to which this electronic
> >> message is addressed. If you are not the intended recipient,
> >> please notify the system manager and
> >> you are hereby notified that any distribution, copying, review,
> >> retransmission, dissemination or
> >> other use of this electronic transmission or the information
> >> contained in it is strictly prohibited.
> >> Please accordingly also note that any views or opinions
> >> presented in this email are solely those of
> >> the author and may not represent those of the Company or bind
> >> the Company. This message has been
> >> scanned for viruses and dangerous content by Mail Scanner, and
> >> is believed to be clean.
> >> The Company accepts no liability for any damage caused by any
> >> virus transmitted by this email.
> >>
> >>
> >> --
> >>
> >> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 7000 subscribers worldwide and receive many nice notes about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send em