Data format in excel

[aditza555]

Hi,

i have a report which has the data format with the format cell - custom - "m/d/yyyy" and i want to change it to format cell - general format - 2/14/2016. Can you please help me ? I am trying but cannot figure how to do it. In the file Formula 1 Subject listin Feb the data format is the good one and in the other Formula 1 Subject listing data format is custom "m/d/yyyy". I need to have it as in the first file.

thank you for all your help.
Adriana

 

[Hui]

Select the cells
Ctrl+1
On the Number Tab, Select Custom
Enter the date format into the Type: Dialog
eg: m/d/yyyy

 

[aditza555]

Hi,

i have a report which has the data format with the format cell - custom - "m/d/yyyy" and i want to change it to format cell - general format - 2/14/2016. Can you please help me ? I am trying but cannot figure how to do it. In the file Formula 1 Subject listin Feb the data format is the good one and in the other Formula 1 Subject listing data format is custom "m/d/yyyy". I need to have it as in the first file.

thank you for all your help.
Adriana

Select the cells
Ctrl+1
On the Number Tab, Select Custom
Enter the date format into the Type: Dialog
eg: m/d/yyyy

Hi Hui,

Sorry but what I want is quite the reverse. i mean to change it from the general format "m/d/yyyy" to format cells / general/ showing the data as 2/16/2016. Would you be able to help me with that?
thank you.
Adriana

 

[Hui]

What is 2/16/2016 if that isn't m/d/yyyy?

What is wrong with that?

I would always reccomend keeping dates as Dates, not text!

 

[aditza555]

What is 2/16/2016 if that isn't m/d/yyyy?

What is wrong with that?

I would always reccomend keeping dates as Dates, not text!

Nothing just that that data i have to copy / paste in a tool that i work and the formulas are going crazy with that format.Can you help?

 

[Hui]

Try using the formula =Text(date,"m/d/yyy")
Where date is the current cells contents or formula