Posts by Caro5228

    Forcing the user was what I was looking for.


    It's because custom number formatting is, for some reason, not available when using excel online.


    However, I have discovered that, although customised number fomatting is not available, I can import a spreadsheet created offline and the customised formatting does transfer. Which will allow my colleagues to continue with their lazy inputs without messing up my spreadsheet. Which works for now.


    But I'd still appreciate a formula if anyone knows how to create it.

    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?