Cant Chage Date format on Spreadsheet

[robertw477]

For some reason I cannot change a colum of data date format. Somebody was working on this file and had the date format as 30/1/08 I want 1/30/08. I select the colum and I right click format cells. I pick the proper date format and nothing changes. Dont know what the issue is. Maybe he locked the column in some way? I appreicate any info. Using Excel 07.

Rob

 

[pedro-egoli]

I tried it on one cell and simply did a custom format of
mm/dd/yyyy

and it worked for me.

Did you just try one cell?
Also is sheet protected?

Pedro

 

[Jon von der Heyden]

how can i tell if a sheet is protected. seems like I can change formats in other columns of data but not the date columns.

rob

Pedro and others - robs reply above...

Hi Rob. You seem to have inadvertently replied using the Report button. You should rather use the Reply button - the Report button doesn't actually append your note to the thread but posts a note to the moderator forum. Report should be used to report spam, abuse, duplicates and other forum rule violations.

 

[pedro-egoli]

Rob,
To check protection go to Tools and click on Protection.

If it shows "Protect " it is not protected.

Pedro

 

[Jon von der Heyden]

Select the column that houses the date.
Go to Text to Columns (Data > Text to columns)
In Step 1 choose Delimited
In Step 2 clear check marks beside all delimiters
In Step 3 choose Date: MDY
Click Finish

 

[robertw477]

That worked.

Thanks
Rob