Changing number to dates

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

Frank Kabel

Hi Craig
format the target cells as 'Text' or insert the values with a leading
apostrophe (')

Frank
 
B

Bill Kuunders

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.
 

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

cannot change date format 4
Excel High lightng dates in future, today and past 1
Access General Date Forced To Have Date And Time 2
Excel Dragging countif formula with changing criteria 3
Date 2
Comparing dates 1
Date and Number cell formats 4
Dates in fomula showing as whole number 10

Top