Forum Discussion
Solved
custom number format
hello. How can I set a cell of consecutive numbers to add spaces in between them? For example a cell having the numbers 12341212 to make it 1234 12 12 and can I save this format?
SergeiBaklanHi, i wish to do the same but with letters included. I want a space between letter and numbers for NI numbers. From JS123456K to JS 12 34 56 K
Nope, customer number format is not applied to texts. You may add helper column in data to transform texts into another form and pivot it.
Thank you SergeiBaklan I did not think I could, but this working from home has sent my brain scatty!