Custom cell formatting

[dminkov]

OK, may be it's simple, but I just couldn't get it:
How to format a cell, containing a number 898223344, to look like 0898 22 33 44?

[Ken Johnson]

Hi dminkov,
format>cells>number>custom>then type "#### ## ## ##" in the Type box
(no speech marks)
Ken Johnson

[Gord Dibben]

Alter that to 0### ## ## ## to get the preceding 0


Gord Dibben Excel MVP

On 2 Dec 2005 01:02:48 -0800, "Ken Johnson" <KenCJohnson@gmail.com> wrote:

>Hi dminkov,
>format>cells>number>custom>then type "#### ## ## ##" in the Type box
>(no speech marks)
>Ken Johnson

[dminkov]

Thank you, but both solutions do not work. The zero is separated from the other three figures... Where am I wrong?

[Ken Johnson]

Hi dminkov,
On my computer 0### ## ## ## in the Type box for the custom format
results in no space between the leading zero and the next digit. Are
you sure you didn't include a space?

Ken Johnson

[dminkov]

Thank you, Ken.
So, I set the same format as yours, of coarse, nothing happens, and when I checked the formatting in "Format Cell", I found out there has been automaticaly added an extra space between 0 and the first symbol... Isn't it strange?

[Ken Johnson]

Hi dminkov,
So you've got it working properly now? I'm guessing yes!

Ken Johnson