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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gildee - 20 Nov 2006 03:36 GMT

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 to this Message

Nick Hodge - 20 Nov 2006 07:54 GMT

Do you have fixed decimals checked?

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
www.nickhodge.co.uk

>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 to this Message

Zack Barresse - 20 Nov 2006 18:47 GMT

The formatting is the same in 2007 as it was in 2003. Ctrl + 1 will still
bring up the dialog box as well.

HTH

Signature

Regards,
Zack Barresse, aka firefytr

Reply to this Message