Text cells converts to dates

J

Jeff

Hello,

I have formatted the cells as "text".

When I type in data, Excel leaves the numbers as is but
when I copy and paste data from the web, it keeps
converting the numbers to a date.

For example,

I can type "11-9 7-13" and the data stays as is BUT when
I copy "11-9 7-13" from two columns on a web page and
paste it, the data is converted to "9-Nov 13-Jul".

What do I have to do to make Excel display those numbers
without converting to a date?

Apparently, formatting the cells as "text" does not work
with pasting.

Thanks.
 
B

BrianB

Obviously "a feature, not a bug" <<grin>>.

Have you checked out the Edit/Paste Special options when pasteing tex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top