Excel Date Format

moses, on Wednesday August 13, 2008 06:36:22 AM

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

Reply to moses Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

Jack Gopher, on Wednesday August 13, 2008 08:45:31 AM

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

This message seems useful, vote!
Report this message to moderators

kp, on Friday October 31, 2008 10:17:55 AM

How can i achieve following stuff through javascript

Reply to kp

This message seems useful, vote!
Report this message to moderators

office, on Tuesday November 11, 2008 08:17:24 PM

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

Ask your question Reply

Results for

Date format in excel. Hello again, Is there a way to make excel read fields left padded with a 0. For example I have a program that only reads date format like this yymmdd, so when I open the csv file in excel it reads 080725 as 80725 instead. Then when I save any changes... en.kioskea.net/forum/affich-16756-date-format-in-excel

DATE FORMATTING IN dd/mm/yyyy Hello, i have got dates typed in the format following 01.08.98 and i want to change it to 01/08/1998 format.i tried applying the format we have in excel format cell date format but nothing is happening.please help me on this. en.kioskea.net/forum/affich-22133-date-formatting-in-dd-mm-yyyy

Change Date Format in XP Hello, The system default short date format is: dd-MM-yyyy. We have an application that runs with the date format in: dd/MM/yyyy. Is there any method (e.g. batch) so that we can change the date format temporary when launch the application and then... en.kioskea.net/forum/affich-5052-change-date-format-in-xp

1 2 3 Next

Results for

InDesign/Quark XPress/Publisher - AlternativesScribus Freware Pageplus SE InDesign/Quark XPress/Publisher - Alternatives Microsoft project is a software for formating and printing project plan usually used by project managers for business and managing budgets. Comparatively to... en.kioskea.net/faq/sujet-303-indesign-quark-xpress-publisher-alternatives

Starting with visual basicStarting with visual basic Visual Basic is a programming tool designed by Microsoft for its Component Object Model (COM). This tool can be used to create applications for windows, web, mobile devices etc.The latest version of Visual basic... en.kioskea.net/faq/sujet-305-starting-with-visual-basic

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

1 2 3 Next

Results for

Date Format issue in my Local MS_XP machineHello, Kindly help me. In My Server Machine having the SQL Database and Server machine Date Format as 'dd/MM/yyyy' and in my Client machine having to run my windows based application where showing the date format as 'mm/dd/yyyy'... en.kioskea.net/forum/affich-9370-date-format-issue-in-my-local-ms-xp-machine

Changin format of date in excelHello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/mm/yy. How can I do that, pls help. eg - I need to convert "sat Jun 29 00:00:00 PST 1996" to "29/06/96".... en.kioskea.net/forum/affich-28689-changin-format-of-date-in-excel

Conditional Format ProblemHello, I want to use Excel Conditional Format to change color of an entire row whenever there is a "cancel" placed in any of the cells in that row. All other information involves taking a value from a column entry, and not a row entry. We have daily... en.kioskea.net/forum/affich-10118-conditional-format-problem

1 2 3 Next

Results for

Databases - Using forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or selecting data.... en.kioskea.net/bdd/bddform.php3

Spreadsheets - The Excel Interface 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 document is called a file... en.kioskea.net/tableur/tabinterface.php3

Data transmission - Digital transmission Digital transmission is the sending of information over a physical communications media in the form of digital signals. Analogue signals must therefore be digitised first before being transmitted. However, as digital information cannot be sent... en.kioskea.net/transmission/transnum.php3

1 2 3 Next