d/m/yyyy h:mm:ss format from General format.Closed

Question

Hello, 
When I download the information from one of our software, I receive the data in following format 15/07/2010 8:10:05 which is in general format. I want it to convert it into d/m/yyyyh:mm:ss or m/d/yyyy h:mm:ss format. Could anyone help me out with the formula.





Configuration: Windows XP / Internet Explorer 7.0

Vivek · Answer

The version of excel is 2007

Trowa · Answer

Hi Vivek,

Select the cell you want to change the format of and press Ctrl+1 or right click and select cell properties. Goto the number tab and select the botom option. Now enter the format you desire.

Best regards,
Trowa

D/m/yyyy h:mm:ss format from General format.

2 replies

Similar discussions

Subscribe To Our Newsletter!