Cells do not Retain Formatting After Pasting.

[Robert Watson]

I have very a simple spreadsheet with lists of names, addresses, telephone
numbers etc.

I have preset the formatting for the telephone number column, to "text" and
centre alignment. When I paste in a telephone number from Outlook Express
such as 01282830756 it changes the format and I lose the first 0 and the
alignment is from the right. After pasting I have to reformat to text and
centre alignment.

This is a real pain and time consuming. Is there any way to cure this and
force Excel to retain the formatting I have set?

Robert

 

[David McRitchie]

Paste the values only.
Edit, Paste Special, Values

 

[Robert Watson]

Is there a shortcut key?

I usually just use Ctrl/V

Robert

Paste the values only.
Edit, Paste Special, Values
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have very a simple spreadsheet with lists of names, addresses, telephone
numbers etc.

I have preset the formatting for the telephone number column, to "text" and
centre alignment. When I paste in a telephone number from Outlook Express
such as 01282830756 it changes the format and I lose the first 0 and the
alignment is from the right. After pasting I have to reformat to text and
centre alignment.

This is a real pain and time consuming. Is there any way to cure this and
force Excel to retain the formatting I have set?

Robert

 

[John Thow]

I have very a simple spreadsheet with lists of names, addresses, telephone
numbers etc.

I have preset the formatting for the telephone number column, to "text" and
centre alignment. When I paste in a telephone number from Outlook Express
such as 01282830756 it changes the format and I lose the first 0 and the
alignment is from the right. After pasting I have to reformat to text and
centre alignment.

This is a real pain and time consuming. Is there any way to cure this and
force Excel to retain the formatting I have set?

Robert

I too have noticed a problem with formatting when copying data from OE (& IE)
into Excel. I found that pasting into the formula bar, rather than directly
into the cell, overcame it.

HTH
--
John Thow
an optimist is a guy/ that has never had/ much experience -
certain maxims of archie; Don Marquis.

To e-mail me, replace the DOTs in the Reply-To: address with dots!