View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default in Excel 2007, how do you remove the decimal point in General

Do you have fixed decimals checked?

Office ButtonExcel OptionsAdvanced TabEditing Options
sectionAutomatically insert a decimal point = uncheck

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

HIS
www.nickhodge.co.uk

"Gildee" wrote in message
...
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