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!
I try this to a column of numbers that come from a pivot table and it does not work. It does though to a normal cell.
- I copied and pasted it to another column and it worked. But it would be great if it can be solved while on a pivot table!
In Pivot Table is the same
In right click menu select Value Field Settings and here is Number format
after that
