SOLVED

Cell format

New Contributor

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?

4 Replies

@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.

S1236.png

@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

Martin670_0-1647953611496.png

 

best response confirmed by Sergei Baklan (MVP)
Solution

@Martin670 

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

 

0000\ 0000\ 00

 

or

 

0000" "0000" "00

Hi
Yes, it worked.
thanks!