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.