J
Jeff
Hello,
I have formatted my cells as "Text" so that when I type
in something like "12-4", Excel doesn't convert the
number to a date.
But when I copy and paste "12-4" from a web site and
paste it, Excel does put it in date form even though I
have formatted the cell as "Text".
How can I get Excel to accept the copied and pasted info
without switching it to a date?
Thanks!
I have formatted my cells as "Text" so that when I type
in something like "12-4", Excel doesn't convert the
number to a date.
But when I copy and paste "12-4" from a web site and
paste it, Excel does put it in date form even though I
have formatted the cell as "Text".
How can I get Excel to accept the copied and pasted info
without switching it to a date?
Thanks!