Cell format

[Martin670]

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?

[#2]

@Martin670 

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.

[#3]

@Hans Vogelaar 

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

[#4 · Accepted solution]

@Martin670 

That is probably because you use a space as thousands separator. Try

0000\ 0000\ 00

or

0000" "0000" "00

[#5]

Hi
Yes, it worked.
thanks!