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