Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
how to make the row become autonumbering in decimal format? mine got problem when it reached 1.10 , it will become 2.1 instead of 1.9,1.10,1.11 also , i can't key in 1.10 , excel will auto numbered it to 1.1 , how to stop this picture as below help pls
Name: jon_k Date: August 4, 2009 at 00:00:59 Pacific
Reply:
When you put in 1.0 in the first cell, put an apostrophe ' before you write the number.
This will make excel think it is text. Now when you drag down the fill handle, autonumbering should work fine.
0
Response Number 2
Name: DerbyDad03 Date: August 4, 2009 at 04:04:30 Pacific
Reply:
If you need the values to be numbers after following jon k's advice, do this:
1.0 - Select an empty cell 1.1 - Press Ctrl-c to copy it 1.2 - Select your list of text numbers 1.3 - Use Edit...Paste Special...Operation: Add 1.4 - Use Format...Cells...Number...Decimal places: 2
Summary: Excel 2002 is not preserving the number format when data is captured through a Word mail merge. Example: 57.70 displays in Excel. After a Word merge you either get 57.7 or 57.700000000003. This wa...
Summary: Hey all, I am using excel 2000 and I need to number rows from 1- 10,000 or so. I know I could use the sum() or count() functions in the first cell and drag it down, but I was wondering if there was in...
Summary: Hi, I have a set of data for which I need to find the average for. ANyway, the problem is, I need to find the average for the lowest 3, the lowest 4, etc out of the set of 12 numbers. Is there any way...
0 
