Text cells converts to dates

  • Thread starter Thread starter Jeff
  • Start date Start date
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.
 
Obviously "a feature, not a bug" <<grin>>.

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