Forum Discussion
how to format a range of numbers in a column of numbers in Excel
I am a user and not an expert. I am given a range of numbers. example: in the format 001000001- 001007000 (Word) Then to Excel (.xlsx) - text 001000001 - 000100700 How do I enter this range of n...
Andrew500 If you are an MS365 subscriber in the Current Channel you could use the SEQUENCE function, like this:
="00"&SEQUENCE(700,,100001,1)Enter it in the first cell where you want the sequence to start.
If you want it to be automated based on the text string, you'll need PowerQuery or VBA. Personally, I prefer the first as it is easier to learn and maintain.