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.
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.