Changing number to dates

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

Guest

When ever I try to paste the characters 6-16 or 4-14 for example it is displayed as a date. I have tried formatting the cells to read this information as text. it is always overridden and converted to a date. How do I paste this info and have it appear the way that I want? Your help will be greatly appreciated.
 
Hi Craig
format the target cells as 'Text' or insert the values with a leading
apostrophe (')

Frank
 
Have you tried to format the cells as text BEFORE you paste into them.
Regards
Bill K
Craig said:
When ever I try to paste the characters 6-16 or 4-14 for example it is
Click to expand...
displayed as a date. I have tried formatting the cells to read this
information as text. it is always overridden and converted to a date. How do
I paste this info and have it appear the way that I want? Your help will be
greatly appreciated.
 
Back
Top