Previous Topic Next Topic

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

Closed
Vivek - Aug 10, 2010 at 06:56 AM
 Trowa - Aug 10, 2010 at 09:02 AM
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.





2 responses

Answer 1 / 2
Vivek
Aug 10, 2010 at 06:57 AM
The version of excel is 2007
0
Answer 2 / 2
Trowa
Aug 10, 2010 at 09:02 AM
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
-1

Similar discussions

How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
date excel userform's textbox
AKS -
rizvisa1 -

1 response
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses
enter date in dd-mm-yyyy
sam -
fdibbins -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses