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