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: www.excelforum.com/member.php...foamp;userid=6365
View this thread: www.excelforum.com/showthread...hreadid=501666Go 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.comquot;Chrispquot; gt;
wrote in message
...
gt;
gt; Is there a way to automatically have a decimal place when
gt; entering
gt; numbers; similar to setting your calculator to automatcally put
gt; in a
gt; second decimal place?
gt;
gt;
gt; --
gt; Chrisp
gt; ------------------------------------------------------------------------
gt; Chrisp's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6365
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501666
gt;
Thanks, this is exactly what I needed.--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile: www.excelforum.com/member.php...foamp;userid=6365
View this thread: www.excelforum.com/showthread...hreadid=501666
- Sep 10 Mon 2007 20:39
Data Entry
close
全站熱搜
留言列表
發表留言