Date Format

  • Thread starter Thread starter Texas Aggie
  • Start date Start date
T

Texas Aggie

I've got a tab delimited document that i need to convert from MM/DD/YYYY to
MMDDYYY.
I tried to replace / with nothing but that didn't work. Any suggestions?

Thanks.
 
I've got a tab delimited document that i need to convert from MM/DD/YYYY to
MMDDYYY.
I tried to replace / with nothing but that didn't work. Any suggestions?

Thanks.
Click to expand...

If it is an Excel recognized date, then either change the cell format:

Format/Cell/Number/Custom Type: MMDDYYYY

or use the formula:

=TEXT(A1,"MMDDYYYY")


--ron
 
Back
Top