Date to text format

  • Thread starter Thread starter nufsed
  • Start date Start date
N

nufsed

I have a date in a cell in the following format 12/15/05. However
need to make this a true text field. I can do it manually by jus
going into that cell and preceding the date with a ' (single quote) s
it would be '12/15/05 but I can't copy this down to all the othe
cells. Anyone know of an easy way to do this
 

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

If statement with dates 0
Conditional Formatting - Dates 2
How to transfer "text" into "date"? 5
Date in wrong format 6
Multiple Lookups 2
Date Formatting 2
Formatting Text to Numbers for Dates 1
Date Format 4

Back
Top