Excel is rounding numbers in ALL formats - how do I stop this?
 

Excel is rounding numbers - regardless of the number of digits or column
width - and regardless of which format I select (phone number, soc sec
number...) If I send the worksheet to another computer, it works fine. If
someone sends a worksheet to me that is working properly, when I open it and
add to it, the numbers are rounded. MAKE IT STOP!!!!

Excel is rounding numbers in ALL formats - how do I stop this?
 

Can you provide an example?

Thx,
JP

On Apr 4, 11:07*am, Janet K. <Janet
wrote:
Excel is rounding numbers - regardless of the number of digits or column
width - and regardless of which format I select (phone number, soc sec
number...) *If I send the worksheet to another computer, it works fine. *If
someone sends a worksheet to me that is working properly, when I open it and
add to it, the numbers are rounded. *MAKE IT STOP!!!!

Excel is rounding numbers in ALL formats - how do I stop this?
 

When I enter 9184561272 in a cell with no formatting selected, I get 91845612
in the column and 91845612.72 in the edit box at the top
If I select the phone number format, I get (9)184-5613


"JP" wrote:

Can you provide an example?

Thx,
JP

On Apr 4, 11:07 am, Janet K. <Janet
wrote:
Excel is rounding numbers - regardless of the number of digits or column
width - and regardless of which format I select (phone number, soc sec
number...) If I send the worksheet to another computer, it works fine. If
someone sends a worksheet to me that is working properly, when I open it and
add to it, the numbers are rounded. MAKE IT STOP!!!!

Excel is rounding numbers in ALL formats - how do I stop this?
 

I found it! ToolsOptionsEditFixed decimal Places was checked. I
unchecked the box and everything is working fine. Must have done this with a
keyboard shortcut and not been aware of it.

Janet

"Janet K." wrote:

Excel is rounding numbers - regardless of the number of digits or column
width - and regardless of which format I select (phone number, soc sec
number...) If I send the worksheet to another computer, it works fine. If
someone sends a worksheet to me that is working properly, when I open it and
add to it, the numbers are rounded. MAKE IT STOP!!!!

Excel is rounding numbers in ALL formats - how do I stop this?
 

Glad to hear it!

--JP

On Apr 4, 12:56*pm, Janet K. wrote:
I found it! *ToolsOptionsEditFixed decimal Places was checked. *I
unchecked the box and everything is working fine. *Must have done this with a
keyboard shortcut and not been aware of it. *

Janet

Excel is rounding numbers in ALL formats - how do I stop this?
 

No keyboard shortcut I am aware of for toggling FD on/off.


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 09:56:01 -0700, Janet K.
wrote:

I found it! ToolsOptionsEditFixed decimal Places was checked. I
unchecked the box and everything is working fine. Must have done this with a
keyboard shortcut and not been aware of it.

Janet

"Janet K." wrote:

Excel is rounding numbers - regardless of the number of digits or column
width - and regardless of which format I select (phone number, soc sec
number...) If I send the worksheet to another computer, it works fine. If
someone sends a worksheet to me that is working properly, when I open it and
add to it, the numbers are rounded. MAKE IT STOP!!!!