Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
in Excel 2007, how do you remove the decimal point in General
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
in Excel 2007, how do you remove the decimal point in General
The formatting is the same in 2007 as it was in 2003. Ctrl + 1 will still
bring up the dialog box as well. HTH -- Regards, Zack Barresse, aka firefytr "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interaction of form controls and pictures in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 - Are Users Experiencing Problems with Charts? | Charts and Charting in Excel | |||
Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
Decimal point will not hold 2 places in Excel 2003 | Excel Worksheet Functions |