How can I defeat Excel's auto-reformating into date format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Seems simple enough - I want a cell to contain the value 5-0. I've tried
pre-formatting the cell to text before copying, I've tried formatting after
pasting - nothing works. As soon as I enter 5-0 Excel converts it to a date.
There is no "paste special" feature that works.

If this were one cell it might be simple enough, but I want to copy a large
table of which this is just one column of several with many rows.

Any ideas?
Thanks,
Steve
 
Hi
try pre-formating the cells as 'Text' and use Paste Special - Values
 
Thank you Frank for your reply, however this doesn't work. The source for my
data is a website, and the "paste special" options I have are html, unicode
text, or text. "Values" is not available for this paste. And as I
mentioned, pre-formatting doesn't help; as soon as Excel sees the 5-0 it
changes the format to a date.


Thanks,
Steve
 
You must log in or register to reply here.

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

Similar Threads

How do I stop Excel from copying date format from cell above? 2
Remove date format? 3
from date format convert to text format is wrong 2
remove the date, leave the time 8
Data being corrupted by excels automatic date recognition re-forma 6
Working with sports W-L records without Excel assuming I want dates... 0
I can't copy and paste equations 0
Resetting cell format from TEXT to NUMERIC and DATE 2

Back
Top