Cells do not Retain Formatting After Pasting.

  • Thread starter Thread starter Robert Watson
  • Start date Start date
R

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
 
I believe pastespecial, values would only be applicable if the data was
being copied from a worksheet as opposed to another application, such as
outlook express as cited by the OP. With the numbers in the original post,
If I do Paste special and select text, it held the pre-set format for me.

--
Regards,
Tom Ogilvy
 
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
Click to expand...
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!
 
Back
Top