View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
LFP LFP is offline
external usenet poster
 
Posts: 6
Default Strange Cell Format Behavior

Thanks so much, no idea how it got set that way in the 1st place.
--
LFP


"BoniM" wrote:

Go to Tools Options Edit tab Fixed decimal places has been set to 2.
Remove the check from fixed decimal places to turn it off, or type 147000 to
enter 1470.

"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