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
Select the cell or cells.
Press Ctrl+1 to activate the Format Cells dialog.
Activate the Number tab.
Select Custom in the list of categories.
Enter
0000 0000 00
in the Type box, then click OK.
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!
