ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/72631-excel-2003-a.html)

barrett

excel 2003
 
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

Chip Pearson

excel 2003
 
Go to the Tools menu, choose Options, then the Edit tab. There,
ensure that "Fixed Decimal" is unchecked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"barrett" wrote in message
...
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





All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com