The text in my cell is numeric and indicates a month/tag#/year (i.e., 1-12345-13 is January-12345-2013 or 11-12345-12 is November-12345-2012).
The formula I tried using (=REPLACE(A1,FIND("-",A1),7,"/"/")+0 is based on the length is always the same and since that is not the case, it is not working properly. Any suggestions on a correction?
Last edited by maryren; 09-20-2013 at 12:11 PM.
what do you mean by date what is the result
do you mean 1-12345-13 should show as January-12345-2013 ? or do you want 1/1/2013
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I would like the end result to be 1/1/2013
=VALUE(LEFT(A1,FIND("-",A1)-1)&"/"&RIGHT(A1,2)+2000) format as mm/dd/yyyy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks