Search : in
By :

Excel Date Format

Last answer on Apr 29, 2009 8:34:16 am BST moses, on Aug 13, 2008 6:36:22 am BST 
 Report this message to moderators

Hello,

when users enter a date in excel using this format 12.1.2008, i need the cell to automatically change the format to 12-Jan-08

thanks,
moses

Configuration: Windows XP
Firefox 3.0.1

Best answers for « Excel Date Format » in :
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...

1

Jack Gopher, on Aug 13, 2008 8:45:31 am BST
  • +2

First an important note: when typing a date into a cell you can't type it with dots like 12.1.2008 (Excel won't understand that as a date) but you have to type it with slashes: 12/1/2008

now for your question:

You can format the date in a cell as you desire by following the next steps:

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 m/d/yyyy , delete it, and type the following instead: dd-mmm-yy
5. Click OK.

The key here is the dd-mmm-yy which sais to Excel: give me the day in two digits, the Month in a word, and the year in two digits.

Good luck!

http://www.free-training-tutorial.com

.

Reply to Jack Gopher

2

kp, on Oct 31, 2008 10:17:55 am GMT
  • +6

How can i achieve following stuff through javascript

Reply to kp

4

 Shyamal- PeopleSoft Cosultant, on Apr 29, 2009 8:34:16 am BST
  • +2

Thanks a lot man, I needed this badly and got this at the right time.

Thanks a ton again...

Cheers,

regards,
Shyamal

Reply to Shyamal- PeopleSoft Cosultant

3

office, on Nov 11, 2008 8:17:24 pm GMT
  • +2

In order to automate the formatting you could record and play a macro each time you want a specific date format in a cell.
Webmaster - http://www.Netwind.com

Reply to office