excel numbering

Microsoft Excel 2000/visual basic for ap...
August 3, 2009 at 21:37:32
Specs: Windows XP

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


See More: excel numbering

Report •

August 4, 2009 at 00:00:59
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.

Report •

August 4, 2009 at 04:04:30
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

Report •

Related Solutions

Ask Question