Excel
Closed
bala
-
Jun 5, 2009 at 02:50 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 5, 2009 at 04:32 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 5, 2009 at 04:32 AM
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.
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:
- Excel
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jun 5, 2009 at 04:32 AM
Jun 5, 2009 at 04:32 AM
Where is the problem ??????? you are giving solution your self ........ implement this to all your sheet .....