Date to text conversion

  • Thread starter Thread starter Toke
  • Start date Start date
T

Toke

Hello everyone. Please help before I lose my mind completely. I have a SS
with a load of flat (apartment) numbers in the format 1/2, 2/3, 3/3, 4/1,
etc. Excel has converted these to dates but I need them to be in text format.
Trouble is that, when I convert to text (or copy - paste as values), excel
displays the dates in their serial format instead of displaying them as they
were shown (1/2 etc). The only way I can fin around this is to re-enter each
value preceded by a single quote but this is becoming impractical as I'm
deling with hundreds of them. Can anyone help?
 
Hope u had copied the data from some other application.

Then try this one selecet the entire coloumn then format it as text.

Now try to copy and past the data in formated coloumn

cheers
rajesh
 

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 to convert OST to PDF? Simple Methods 2
Why this paste result? 4
Date Conversion 6
Date Conversion 2
Convert dates stored as text 2
date to text 1
Best Ways to Convert OST to PDF? 3
Date & Time conversion????? 1

Back
Top