 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Expanding default # of scientific notation
I wonder how I can expand the length of digits allowed before it goe into that scientific notation. So far I can get up to 11 digits: 12345678901 before it converts: 123456789012 into: 1.23457E+11 Is there a way to expand this so it can be more than 11 digits for AL documents now and in the future Change format to "Number' and expand the column width. You should only see that scientific notation when the font is General and the column is too narrow.  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== I wonder how I can expand the length of digits allowed before it goes into that scientific notation. So far I can get up to 11 digits: 12345678901 before it converts: 123456789012 into: 1.23457E+11 Is there a way to expand this so it can be more than 11 digits for ALL documents now and in the future? Signaturekrayziez ------------------------------------------------------------------------ krayziez's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34891 View this thread: http://www.excelforum.com/showthread.php?threadid=563996 Yes I already know that. I need to do it so it is global on all sheets and for all future sheets. It should be a system change, not just a cell change. I need to change the DEFAULT # of digits before it goes into scientific notation. I need it to be at least 35.. It's very annoying to have to change it each and every single time. I sell on eBay and they recently increased their item numbers to hold about 15 digits. This makes it very annoying to deal with. Signaturekrayziez So you're really *not* talking numbers. Credit cards and styles and model numbers are all treated the same as 'Text', since there really is no calculation involved. *Pre*-format the cells (columns - rows) involved to *TEXT*. When done *before-hand*, you can enter as many digits as you wish without running into this problem. On a cell by cell basis, just prefix any individual entries with an apostrophe ( '123 ), which will tell XL it's text (no matter what the cell's original format is), where the apostrophe will *not* display in the cell itself, but will be visible in the formula bar. SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== Yes I already know that. I need to do it so it is global on all sheets and for all future sheets. It should be a system change, not just a cell change. I need to change the DEFAULT # of digits before it goes into scientific notation. I need it to be at least 35.. It's very annoying to have to change it each and every single time. I sell on eBay and they recently increased their item numbers to hold about 15 digits. This makes it very annoying to deal with. Signaturekrayziez ------------------------------------------------------------------------ krayziez's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34891 View this thread: http://www.excelforum.com/showthread.php?threadid=563996 Pre-formatting anything will not do. That involves me doing something. I want it automatic. I open hundreds of sheets each week. I don't want to have to format any cell each time I open a new sheet. The sheet gets exported to me and the numbers are already there, with scientific notations. I want the numbers as is without me doing anything. This is the same concept as say having grids print/not print on every sheet by choosing a particular setting in Excel. Same thing with Word for example where you can pre-select a font so that ALL documents are in Arial instead of the default Times for example. Signaturekrayziez If you're saying that you receive the sheets with those scientific notations *already* being displayed, AND ... you don't want to have to do anything, WHAT *exactly* are you asking for at this news group? You should maybe try to convince whoever is sending you these sheets to try and correct them at their side. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > Pre-formatting anything will not do. That involves me doing something. I [quoted text clipped - 7 lines] > for example where you can pre-select a font so that ALL documents are > in Arial instead of the default Times for example. I don't know why it's so hard to understand this. If you download a lis of item numbers that are say 15 digits long, all of them will hav scienctific notations automatically because XL sees it as a number an wants to shorten it. Now I can format it into a number and that wil solve the problem, but I'd then have to do this EVERY SINGLE TIME download the list of item numbers. I'm saying I want the default to b a bit more digits before it automatically goes into scientifi notations. I think you're thinking too much into this. It's a simpl problem, but the answer is unknown at the time >Pre-formatting anything will not do. That involves me doing something. I >want it automatic. I open hundreds of sheets each week. I don't want to [quoted text clipped - 6 lines] >for example where you can pre-select a font so that ALL documents are >in Arial instead of the default Times for example. Are you "opening workbooks" or are you importing data into a workbook of your own? Regardless, you will need to somehow widen the column and, if the strings are greater than 15 digits, format those cells as text. If you are copying the information into an already open workbook, you could set up a personal.xls file formatted the way you want. If you are opening other workbooks, a macro solution might be useful where you can set up a button that accomplishes the task. --ron OK. I already know how to do macros and all that. But I don't want to do macros for every single file I import because all of them are different. So the short answer is, there is no system configuration to set it where the scientific notation is greater than the default of 12 correct? That's all I want to know. I know how to do everything else mentioned. Problem with everything else is ITS NOT AUTOMATIC. Example, If I wanted to print grid on every single paper I print on, then all I have to do is check mark that default on so that every single page from now til the day I die is printed with a grid without me having to do ANYTHING. That means, I don't have to format all cells and hit the all sides bordering option Signaturekrayziez >OK. I already know how to do macros and all that. But I don't want to do >macros for every single file I import because all of them are different. [quoted text clipped - 7 lines] >means, I don't have to format all cells and hit the all sides bordering >option You write you "know how to do macros". What do you mean when you write you "don't want to do macros for every single file" you import? Just write a single macro that makes the adjustments after you open the relevant file. If you have it attached to a button that's on your toolbar, you would have to do one extra mouse-click each time you import a new file. You could probably even automate that. --ron
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.