Changin format of date in excel

drizn, on Wednesday 8 October 2008 à 03:23:07

Hello,

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". How can I. Any help is appreciated.

Configuration: Windows XP
Internet Explorer 7.0

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

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

karina, on Wednesday 8 October 2008 à 05:56:45

go to Format Cells, click on Number Tab and then select Custom and type dd/mm/yy under Type:

Reply to karina

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

drizn, on Wednesday 8 October 2008 à 22:50:34

Tried that but it isnt working.

Reply to drizn

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

chomps, on Wednesday 19 November 2008 à 09:19:04

I have exactly the same problem I cant change the format of the date in a cell. I have 34000+ cells and I am not going to change each one manually by retyping in the date

Please tell me if you got this right....

Reply to chomps

Ask your question Reply

Results for

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

Lotus to Excel formula conversion p Hello, I'm trying to convert a lotus formula to excel but have run into problems with multiple nested IF formula's 9to many)... The formula works in Lotus but not Excel. I'm sure there is a more efficient way to find the values using... en.kioskea.net/forum/affich-4843-lotus-to-excel-formula-conversion-p

Lotus to Excel formula conversion Hello, I'm trying to covert a Lotus formula to Excel but have run into problems with multiple nested IF formula's (to many)... The formula works in Lotus but not Excel. I'm sure there is a more efficient way to find the values using... en.kioskea.net/forum/affich-9958-lotus-to-excel-formula-conversion

1 2 3 Next

Results for

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

How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf

How to insert picture background on Microsoft!How to insert picture background on Microsoft! To make a work sheet more appealing, you can add picture to your background. Below is a tip for doing so. Open your Microsoft and select “Format”> “Backgrounds” > “Printed... en.kioskea.net/faq/sujet-334-how-to-insert-picture-background-on-microsoft

1 2 3 Next

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

Change of dateHello, my pc's time & date automically changes to 07:30 AM ,05 sep. 2020, on every start up . i have win. xp operating system en.kioskea.net/forum/affich-29834-change-of-date

Format data in excel for Db transactionHello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end of each number. That way I can transfer this list into Oracle as strings easily. This could be done... en.kioskea.net/forum/affich-23592-format-data-in-excel-for-db-transaction

1 2 3 Next

Results for

Download MP3-CheckFormat MP3 is audio format par excellence for audio compression. But it is really possible that there are errors in formats, notably graffiti there. MP3-Check is an application which allows to prove your music collection for quality and possible... en.kioskea.net/telecharger/telecharger-696-mp3-check

Download Switch File Format ConverterSwitch is an utility of audio conversion for Windows. Switch is very easy to use. It is enough to add the file to convert in the list, to choose desired format and to clicker conversion on the button.It inserts a simple and intuitive interface. The... en.kioskea.net/telecharger/telecharger-785-switch-file-format-converter

Download BitMeter IIBitMeter II is a bandwidth monitoring application that runs in the background, logging important and statistical data, logging important and statistical data, regarding your network's Internet connection speeds. It’s easy to use, yet its robust... en.kioskea.net/telecharger/telecharger-227-bitmeter-ii

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

Spreadsheets - Data Entry A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example 3.1415927, 58%,... en.kioskea.net/tableur/tabsaisie.php3

1 2 3 Next