ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do you make a column number its self in order from a given # (https://www.excelbanter.com/excel-programming/353854-how-do-you-make-column-number-its-self-order-given.html)

jasond

How do you make a column number its self in order from a given #
 
How do you make a column number its self in order from a given # infinitly?
A1 beginning with 045000 and A2 being 045001...

Norman Jones

How do you make a column number its self in order from a given #
 
Hi Jason,

In A1 type '045000 (note the initial apostrophe)
Right-click A1 and drag down as far as required
Select the Fill Series option.


---
Regards,
Norman



"jasond" wrote in message
...
How do you make a column number its self in order from a given #
infinitly?
A1 beginning with 045000 and A2 being 045001...





All times are GMT +1. The time now is 10:41 PM.

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