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
 
Top