I need to use data validation to enforce input of a number in the format ### ### #### (So, a ten figure number with a single space after digits 3 and 6)
I cannot use number formatting as this is not available in the online version of excel that my employer uses.
Please could someone help me with a formula for this?