Forum Discussion
Solved
Cell format
Hi I have a 10 digit item No. I'd like to convert from beeing in one block to have the format of XXXX XXXX XX. Ex. 0123456789 to 0123 4567 89 How do I do this?
That is probably because you use a space as thousands separator. Try
0000\ 0000\ 00
or
0000" "0000" "00
It doesn't work for me
I try to change 4210218402 to be 4210 2184 02 and use 0000 0000 00
In my cell it will look like below
That is probably because you use a space as thousands separator. Try
0000\ 0000\ 00
or
0000" "0000" "00
- Hi
Yes, it worked.
thanks!