Excel [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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.

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
Where is the problem ??????? you are giving solution your self ........ implement this to all your sheet .....

1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!