View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Strange Cell Format Behavior

Tools Options Edit Uncheck Fixed decimal Places:


"LFP" wrote:

I have my cells formatted as general. When I input the number 1470 it makes
it 14.7 When I switch the formatting to a number with no decimal places and
type in 1470 it changes it to the number 15. I just want to input the whole
number 1470.
--
LFP