Data Entry
 

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

Data Entry
 

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

Data Entry
 

Thanks, this is exactly what I needed.


--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile: http://www.excelforum.com/member.php...fo&userid=6365
View this thread: http://www.excelforum.com/showthread...hreadid=501666