G
Guest
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
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