how to format a range of numbers in a column of numbers in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2608244%22%20slang%3D%22en-US%22%3Ehow%20to%20format%20a%20range%20of%20numbers%20in%20a%20column%20of%20numbers%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2608244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20user%20and%20not%20an%20expert.%3CBR%20%2F%3EI%20am%20given%20a%20range%20of%20numbers.%3CBR%20%2F%3Eexample%3A%3CBR%20%2F%3Ein%20the%20format%20001000001-%20001007000%20(Word)%3CBR%20%2F%3EThen%20to%20Excel%20(.xlsx)%20-%20text%20001000001%20-%20000100700%3C%2FP%3E%3CP%3EHow%20do%20I%20enter%20this%20range%20of%20numbers%20in%20Excel%20(.xlsx)%20so%20that%20they%20convert%20to%20a%20column%20of%20numbers%3F%3CBR%20%2F%3Eis%20there%20an%20easy%20way%3F%3CBR%20%2F%3EOr%20do%20I%20need%20an%20additional%20program%20and%20which%20program%3F%3CBR%20%2F%3Ehow%20do%20I%20do%20this%20at%20all%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2608244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2608299%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20format%20a%20range%20of%20numbers%20in%20a%20column%20of%20numbers%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2608299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1119916%22%20target%3D%22_blank%22%3E%40Andrew500%3C%2FA%3E%26nbsp%3BIf%20you%20are%20an%20MS365%20subscriber%20in%20the%20Current%20Channel%20you%20could%20use%20the%20SEQUENCE%20function%2C%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3D%2200%22%26amp%3BSEQUENCE(700%2C%2C100001%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BEnter%20it%20in%20the%20first%20cell%20where%20you%20want%20the%20sequence%20to%20start.%3C%2FP%3E%3CP%3EIf%20you%20want%20it%20to%20be%20automated%20based%20on%20the%20text%20string%2C%20you'll%20need%20PowerQuery%20or%20VBA.%20Personally%2C%20I%20prefer%20the%20first%20as%20it%20is%20easier%20to%20learn%20and%20maintain.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 numbers in Excel (.xlsx) so that they convert to a column of numbers?
is there an easy way?
Or do I need an additional program and which program?
how do I do this at all?

1 Reply

@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.