close

first time using excel 2003 (long time excel user). it won't let me type in
numbers in the hundred thousands, ie 643,250 comes out 64,325. i went to the
number format and put in standard 'use commas for thousands, brackets for
negative etc...and it still won't let me type in a 6 dig number

Go to the Tools menu, choose Options, then the Edit tab. There,
ensure that quot;Fixed Decimalquot; is unchecked.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;barrettquot; gt; wrote in message
...
gt; first time using excel 2003 (long time excel user). it won't
gt; let me type in
gt; numbers in the hundred thousands, ie 643,250 comes out 64,325.
gt; i went to the
gt; number format and put in standard 'use commas for thousands,
gt; brackets for
gt; negative etc...and it still won't let me type in a 6 dig number

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

    software

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