Go to the Tools menu, choose Options, then the Edit tab. There,
check the Fixed Decimal setting.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Chrisp"
wrote in message
...
Is there a way to automatically have a decimal place when
entering
numbers; similar to setting your calculator to automatcally put
in a
second decimal place?
--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile:
http://www.excelforum.com/member.php...fo&userid=6365
View this thread:
http://www.excelforum.com/showthread...hreadid=501666