View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Precision As Displayed Has Failed Me--Help

Thanks, but it's plenty wide and when I check the formatting, it's the same
as the others.

Another thing I should add is that the worksheet is protected (except
obviously for the area where the value is entered), but I'm not sure how that
would affect anything.

"Jim Rech" wrote:

Best guess is that the cell now has General number format due to the
copy/paste. If the column width is narrow enough 3.67 will display as 3.7.

--
Jim