Changing number to dates

C

Craig

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

How can the font and size of (all) citation numbers be altered? 1
Date Formats 4
Excel does not accept text format! 0
Paragraph numbering in Word 1
Paste to excel from word - auto format problem 1
How to change font & size of (all) citation numbers? 7
Project Start and End Date is not consistent 1
Finding the proper style field and the numbered paragraph value within the style 0

Top