Increase the last number not the first

[xeven_]

When I hold down control and drag down the cell it increases my (first/whole number) how can I make it increase the last digit instead?

NOT LIKE THIS	LIKE THIS
1.33280	1.33280
2.33280	1.33281
3.33280	1.33282
4.33280	1.33283
5.33280	1.33284
6.33280	1.33285

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[xeven_]

Rick,
AWESOME THAT'S IT!!!

Thank you for the help and great to still see you posting here.

Thank you too Shettigar I'm still trying to make that one work.

 

[Rick Rothstein]

without column A how do I make it increase to appear as the column B you have above

Let's start again... convert what ever cell you want to start in to TEXT, then put your number (1.33280) into the cell, then copy it down. The cell must be formatted as TEXT first, before entering the value into it, in order to stop Excel from being "helpful" and converting things that look like numbers or dates into real numbers or dates).

 

[xeven_]

That's it thanks