Text to Columns

B

Bob L

How do I keep the format of the cells to remain as text when preforming Text
to Columns. I have cells that have numbers such as 10-4-4 formated as text.
After preforming Text to Columns the cells come up with the date 10/4/2004,
and the format was changed automatically to date. I want to keep it as text,
10-4-4. TIA Bob
 

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

Top