Excel question (1 Viewer)

[Spike]

I have a spreadsheet which has a column of dates that I hope someone in the community can help me reformat.

The dates are in the format of "mm/dd/yyyy" but the "mm" and "dd" isn't always 2 characters BUT I NEED IT TO BE.

For example, if the date is June 7th, 2007, the date appears as "6/7/2007".

I need both "mm" and "dd" to be 2 characters every time.

So, from the prior example, the date needs to be "06/07/2007".

Can anyone help with this? I don't want to manually change all of these.

 

[Spike]

Could I please have this moved to the proper forum? (Sorry about the mistake!)

 

[Jethro]

This should do it...

Highlight the cells

Click on 'Format'

Select 'Cells'

Scroll to the bottom on the Category side and select 'Custom'

Enter 'mm/dd/yyyy' without the quotes and click 'OK'

 

[shadyridr]

EDIT>FORMAT CELLS> CUSTOM> Type in mm/dd/yyyy in the box

 

[jmills]

highlight all the cells in question. Select Format-Cells Click on the Number tab. Under category select Custom. In the Type window, type the following. mm/dd/yyyy;@

This should take care of it

 

[Spike]

Jethro/Shadyridr/Jmills - thanks a lot! It worked like a charm.