TODAY() function to text

Hello,

I need to find a way to take the TODAY() function and and split the individual digits out and recombine them to a text cell, i have tried using the MID function but it returns the serial rather than the actual number, e.g

today() 02/01/2009 needs to be shown as 020108 (this needs to be text rather than a number) as it is included within an INDIRECT formula.

any ideas
thanks reg

Try this:

Please Login or Register  to view this content.

Does that help?

Originally Posted by Ron Coderre

Try this:

Please Login or Register  to view this content.

Does that help?

I reckon it would if it was:

=TEXT(TODAY(),"ddmmyy")



Richard

Note that I am assuming the OP made a small error in his original post requesting that 02/01/09 be returned as 020108

DOH! You're right, of course....Thanks for catching that.