Expanding default # of scientific notation

[krayziez]

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

 

[RagDyeR]

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.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
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?

 

[krayziez]

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.

 

[RagDyeR]

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.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
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.

 

[krayziez]

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.

 

[Ragdyer]

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.

 

[krayziez]

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

 

[Ron Rosenfeld]

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.

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

 

[krayziez]

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

 

[Ron Rosenfeld]

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

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