G
Guest
When I type numeric numbers in a cell they change to a type of formula when I
exit the cell. How do I get them to stay numeric only?
exit the cell. How do I get them to stay numeric only?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyeR
I just can't picture what you're describing.
Could you post some examples?
Could you post some examples?
G
Gord Dibben
George
Post an example of the numbers you type and the formula you see when you exit
the cell.
Or maybe one of the psychics in here will not need that info<g>
Gord Dibben MS Excel MVP
Post an example of the numbers you type and the formula you see when you exit
the cell.
Or maybe one of the psychics in here will not need that info<g>
Gord Dibben MS Excel MVP
G
Guest
Example: 610300012569 changes to 6.103E+11
R
RagDyeR
Make the cell wider and/or change the format from General to Number.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Example: 610300012569 changes to 6.103E+11
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Example: 610300012569 changes to 6.103E+11
R
RagDyeR
In General format, when the cell is not wide enough to display the number,
the number can be displayed in any of 3 forms.
Very narrow = #####
Little wider = 6.103E+11
Wide Enough = 610300012569
In Number format, it'll either be
#####
OR
the actual number.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Example: 610300012569 changes to 6.103E+11
the number can be displayed in any of 3 forms.
Very narrow = #####
Little wider = 6.103E+11
Wide Enough = 610300012569
In Number format, it'll either be
#####
OR
the actual number.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Example: 610300012569 changes to 6.103E+11
G
Guest
Thanks for your info...changing to number format worked; however, I am not
sure why I had to do that as the cell is quite a bit wider than the string of
numbers.
sure why I had to do that as the cell is quite a bit wider than the string of
numbers.