Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.

I am seeing the answer in your Subject itself.

Try this...

Now your Format is like this # ### ###
You just change it to ### ####

Place your cursor in A1 cell and do right click from your mouse and select
Format CellsNumberCategoryCustomType field past this ### ####

Now it will be changed.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.

I know that it should be work like that, but it automatically change it back
to # ### ### after i click OK in Format Cells windows.

Any suggestions?

"Ms-Exl-Learner" wrote:

I am seeing the answer in your Subject itself.

Try this...

Now your Format is like this # ### ###
You just change it to ### ####

Place your cursor in A1 cell and do right click from your mouse and select
Format CellsNumberCategoryCustomType field past this ### ####

Now it will be changed.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.

I think I found the answer.

I thought that it was formatted like # ### ###, but when I go through the
numbers once again (6 555 555) I found that the data consist manual spaces.

Just Select the Column in which the data are lying or select the range and
press Cntrl+H and in Find What Box give a space and in Replace with field
leave it as blank. Now hit Replace All. Finally Select the range and apply
the below format.

Format CellsNumberCategoryCustomType field past this ### ####

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

I know that it should be work like that, but it automatically change it back
to # ### ### after i click OK in Format Cells windows.

Any suggestions?

"Ms-Exl-Learner" wrote:

I am seeing the answer in your Subject itself.

Try this...

Now your Format is like this # ### ###
You just change it to ### ####

Place your cursor in A1 cell and do right click from your mouse and select
Format CellsNumberCategoryCustomType field past this ### ####

Now it will be changed.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.

There was made 1 replacement, but it still changes back format. I thought
maybe i should install SP2? I will try to do changes after i intalled SP2.
Will reply later.

"Ms-Exl-Learner" wrote:

I think I found the answer.

I thought that it was formatted like # ### ###, but when I go through the
numbers once again (6 555 555) I found that the data consist manual spaces.

Just Select the Column in which the data are lying or select the range and
press Cntrl+H and in Find What Box give a space and in Replace with field
leave it as blank. Now hit Replace All. Finally Select the range and apply
the below format.

Format CellsNumberCategoryCustomType field past this ### ####

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

I know that it should be work like that, but it automatically change it back
to # ### ### after i click OK in Format Cells windows.

Any suggestions?

"Ms-Exl-Learner" wrote:

I am seeing the answer in your Subject itself.

Try this...

Now your Format is like this # ### ###
You just change it to ### ####

Place your cursor in A1 cell and do right click from your mouse and select
Format CellsNumberCategoryCustomType field past this ### ####

Now it will be changed.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.

Try this...

=TEXT(SUBSTITUTE(A1," ",""),"### ####")

copy and paste it to the remaining cells.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

There was made 1 replacement, but it still changes back format. I thought
maybe i should install SP2? I will try to do changes after i intalled SP2.
Will reply later.

"Ms-Exl-Learner" wrote:

I think I found the answer.

I thought that it was formatted like # ### ###, but when I go through the
numbers once again (6 555 555) I found that the data consist manual spaces.

Just Select the Column in which the data are lying or select the range and
press Cntrl+H and in Find What Box give a space and in Replace with field
leave it as blank. Now hit Replace All. Finally Select the range and apply
the below format.

Format CellsNumberCategoryCustomType field past this ### ####

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

I know that it should be work like that, but it automatically change it back
to # ### ### after i click OK in Format Cells windows.

Any suggestions?

"Ms-Exl-Learner" wrote:

I am seeing the answer in your Subject itself.

Try this...

Now your Format is like this # ### ###
You just change it to ### ####

Place your cursor in A1 cell and do right click from your mouse and select
Format CellsNumberCategoryCustomType field past this ### ####

Now it will be changed.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Lion2004" wrote:

Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.

Format Cells/ Number/ Custom
--
David Biddulph

"Lion2004" wrote in message
...
Hi,

I'm using Office 2007.
I need to change in cell "A1" number format from 6 555 555 to 655 5555.

How can i do this change?

Thank you.
Peeter.