close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()