Forum Discussion
ChristyQuaedvlieg
Oct 11, 2020Copper Contributor
Numbers with spaces in them
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 ...
Riny_van_Eekelen
Oct 11, 2020Platinum Contributor
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.