Numbers with spaces in them

[ChristyQuaedvlieg]

I have to create a sheet with consecutive15 digit numbers. When I enter the 15 digit number with spaces between every third number excel will not let me create a list with consecutive numbers. If  I remove the spaces it works. Is there a way to make it recognize the spaces? or should I create the list with out spaces and then is there a way to add the spaces to the entire column after it has been created?

  Example of number  124 000 199 264 100

[#2]

You could create the list w/o spaces and then put the spaces in using a formula (assuming all of the numbers are 15 digit).

=TEXTJOIN(" ",,MID(A1,{1,4,7,10,13},3))

Then, copy/paste special value to hardcode the formula results and you could get rid of the numbers w/o spaces.

[#3]

@ChristyQuaedvlieg If adding the spaces is a mere cosmetic issue, you may custom format the 15-digit number as 000 000 000 000 000.

It will remain a number but just displayed with spaces between every group of three digits.