Excel 2007

Since upgrading to above, I cannot format cells for whole numbers. Allthough
I can find the Numbers format and modify it to 0 decial places it will not
allow me to do this and persists in entering whole numbers as two places of
decimals I am working on a spreadsheet right now which has to be completed by
the end of today.
Can anyone help me please
Frank

Found the answer !!!. Uncheck the box in advanced options

Thanks anyway

"Craneman" wrote:

> Since upgrading to above, I cannot format cells for whole numbers. Allthough
> I can find the Numbers format and modify it to 0 decial places it will not
> allow me to do this and persists in entering whole numbers as two places of
> decimals I am working on a spreadsheet right now which has to be completed by
> the end of today.
> Can anyone help me please
> Frank

Craneman <Craneman@discussions.microsoft.com> wrote:

> Found the answer !!!. Uncheck the box in advanced options

You're welcome even though I didn't do anything, but maybe I can help a
bit by telling you that in the future you'll get better and faster
answers to questions about MS Office in one of the Office newsgroups
such as:

microsoft.public.office.misc

You'll find newsgroups for Excell, Word, Access, Outlook and who knows
what else... ;-)

Glad you found the fix and thanks for letting us know!


--
XS11E, Killing all posts from Google Groups
The Usenet Improvement Project: http://blinkynet.net/comp/uip5.html

It's in advanced options

--

http://www.goldwatches.com/watches.asp?Brand=14
"XS11E" <xs11e@NOSPAMyahoo.com> wrote in message
news:Xns996DDF96B3C38xs11eyahoocom@127.0.0.1...
> Craneman <Craneman@discussions.microsoft.com> wrote:
>
>> Found the answer !!!. Uncheck the box in advanced options
>
> You're welcome even though I didn't do anything, but maybe I can help a
> bit by telling you that in the future you'll get better and faster
> answers to questions about MS Office in one of the Office newsgroups
> such as:
>
> microsoft.public.office.misc
>
> You'll find newsgroups for Excell, Word, Access, Outlook and who knows
> what else... ;-)
>
> Glad you found the fix and thanks for letting us know!
>
>
> --
> XS11E, Killing all posts from Google Groups
> The Usenet Improvement Project: http://blinkynet.net/comp/uip5.html
>