Format the column as text-go into Formatcellscustom and type this in for
custom format.Worked for me.
Pat

(0##) ###-####

"Hnelg" wrote:

Hi,

I have a column of cells with telephone numbers in it and I wish to convert
- or copy and paste these cells - into text format.

For example, I have a telephone number as 083270000 and the cell properties
(Format Cells Category) is listed as "Custom" and the "Type" is listed as
"000000000".

When I conduct a copy and paste, I lose the preceding zero before the eight.
But I need this to remain and I need all the cells in "Text" format!

Any ideas on how to do this?

Regards
Hnelg