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?
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