Excel Formatting and sorting dates
Last answer on Apr 28, 2009 8:46:17 am BST blackdog11, on Apr 27, 2009 6:54:17 am BSTHello,
Problem....
I'm entering dates into Excel. I need these dates date in the format "ddmmyyyy" with leading zeroes where the day is < 10 e.g. Fifth of August 2009 will display as "05082009"
When I type the string "05082009", it changes it to "5082009"
If I format the cell as a custom format of "00000000" to attempt this, I lose the date format and the columns sort as strings, not dates.
...I hope you'll help me
Configuration: Windows XP Internet Explorer 7.0
Best answers for « Excel Formatting and sorting dates » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a 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 time, press CTRL¯+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Colouring cells on conditions ShowColouring cells on conditions
There are many pratical functions under Excel which is not commonly used.
Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
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...
