in Excel 2007, how do you remove the decimal point in General

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to format numbers in the General catagory but Excel puts a
decimal in the number and I cannot remove it; I have tried using the General
and Number formatting fields but nothing is working, I just want to type in
the year and or a general number..thats all
 
Do you have fixed decimals checked?

Office Button>Excel Options>Advanced Tab>Editing Options
section>Automatically insert a decimal point = uncheck

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 
The formatting is the same in 2007 as it was in 2003. Ctrl + 1 will still
bring up the dialog box as well.

HTH
 
Back
Top