Convert Wed, Oct 28, 2009 to 20091028

[beanzNY]

imported from external source but it wont let me format the cell using format cell menu... anyone know how i can change it so it looks like 20091028 or essentially yyyymmdd

 

[Airfix9]

It should let you format. But it not, try:

=VALUE(TEXT(A1,"yyyymmdd"))

 

[Haseeb Avarakkan]

Hello,

If your dates are always in ddd, mmm d, yyyy format, try this;

=TRIM(MID(A1,5,15))+0

Change the cell format to yyyymmdd

 

[beanzNY]

ok i figured out how to format it... i didnt format to the yyyymmdd instead i formated it to mmddyy so the spreadsheet looks better however i need to be able to format the dates behind the scenes in 1 of my macros. i need to give 1 of my variables the value of the dates but need to convert it to the yyyymmdd so i can import data from a website that uses the yyyymmdd format for each page.
e.g. www.basketball-reference.com/boxscores/yyyymmdd/team_name.html

 

[T. Valko]

Disregard

 

[beanzNY]

i got it text(a1,"yyyymmdd")