rearranging text in a cell

P

peacekeeper

Would someone please tell me how to rearrange the text
entries in a column of cells that indicates the date when
a certain lab test was performed. For example, the cell
currently shows:

"6219805" which corresponded to a mddyy##

and I want it to read instead as:

"1998062105"

That is, yyyymmdd##

Thanx for your help!
 

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

I need Help 0
Show a cell's formula in text format in a linked cell 2
how to return "summary" of all non-blank cells plus their headers 10
finding text and performing a calculation 1
Cell content capture and release 0
Conditional Format for Blank Cells 5
Change the colour of a cell if another named cell is blank 2
Problem using IF statement with dates as part of the formula 4

Top