How can I enter a format for a number that will appear when input as
follows, and also have a Data Validation that ensures there is 8 numbers
typed in

0 1 2 3 4 5 6 7 (not there is a single space between characters)

I have tried format as Custom # # # # # # # # with a Data Validation of 8 -
but this doesn't work where the first number is Zero, I assume Excel doesn't
recognise the Zero and thinks that there is only 7 numbers enter

I need the spacing between each, thanks