Excel

Closed
bala - 5 Jun 2009 à 02:50
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 5 Jun 2009 à 04:32
Hello,

when users enter a date in excel using this format 12-01-2008,
i need the cell to automatically change the format to 12/01/2008

i have try this steps.what to do

1. Select the cell(s) containing the date(s).
2. Open the menu "format" and choose "cells".
3. On the list on the left choose "custom"
4. In the "type" text field you will see something like dd/mm/yyyy , delete it, and type the following instead: dd-mm-yyyy
5. Click OK.
Related:

1 response

mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
5 Jun 2009 à 04:32
Where is the problem ??????? you are giving solution your self ........ implement this to all your sheet .....