Thread: Data Entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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