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 <svyas0...@gmail.com> 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 > > <saurabh.pa...@in.aegisglobal.com> 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 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 > > > > > > -- > The posting are downloaded from various sites so the sender is not > liable for any mishape or damage or anything. download and install at > your own rist. This might be posted somewhere else in the group, hence > may be repeated... > > > > > -- > Ï,¸,ø¤*°'°*¤ø,--_V I J ā Y _--,ø¤*°'°*¤ø,¸¸,Ò © > > -- > ---------------------------------------------------------------------------------- > 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 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