Will that behave as number? that will behave as text then
On Sat, Feb 26, 2011 at 8:57 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > XL has a specification limit of 15 decimal digits of precision (see > Help, "Specifications"). There's nothing you can to in XL itself to > extend the precision. There are a few add-ins around that you can Google > that claim to give up to 200 decimal digits of precision, but I haven't > tried any of them. > > > > Regards, Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ashish Khandelwal > *Sent:* Saturday, February 26, 2011 1:31 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Entry of more than 16 characters in a cell > > > > Hi friends, > > > > > > When I enter a 16 digit number in a cell, the last digit become 0. How can > I enter a 16 or more digit number in a cell. > > > > > > Thanks & Regards, > > > > Ashish. > > > > > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?????? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
