Excel 2007

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

Guest

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 said:
Found the answer !!!. Uncheck the box in advanced options
Click to expand...

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for decimal point 4
format 9
Excel Excel 2007 won't stop rounding down my formula results! 5
Automatically chnage number format of a range of cells 2
Access stripping decimal places in query 1
problem with number format with 2 decimals? 5
Excel Excel 2007 Rounding 1
How can I change the default number of decimal places in Excel? 1

Back
Top