Previous Topic Next Topic

Excel

Closed
anand - Feb 2, 2015 at 07:03 AM
 Blocked Profile - Feb 2, 2015 at 08:58 AM
Hello,
I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003
Please solve my problem urgently
Related:

1 response

Answer 1 / 1
Blocked Profile
Feb 2, 2015 at 08:58 AM
Hello,

you need to go to highlight the cell or cells.

right click the cell or cells and go to "format cells"

Select "Date" from the category and then in the type select "14.3.12" and press OK.

you could always click Custom and type dd.mm.yyyy and press OK.




0

Similar discussions

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

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses