Decimels in numbers

M

Molly

When I enter the year 2007 in cell it shows as 20.07. How do I
set formula so that decimal point does not enter number?
 
C

CyberTaz

Hi Molly -

Take a look in Excel> Preferences> Edit & clear the check on "Display this
number of decimal places:".


HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Excel does not accept text format! 0
How to count the numbers in a Word document? 0
Autonumber field in Excel that behaves the same as Access 0
bookkeeping snag 5
Paragraph numbering in Word 1
Formatting question: how to format duration (time spent)? 0
Mail Merge - displaying a conditional number of decimals 5
Delete all data after a symbol in a field 0

Top