| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format date dd.mm.yyyy to dd/mm/yyyy
Hi,
For exporting purposes to a database, I have to have the dates formatted as dd/mm/yyyy. Easy you say. Yes, I have formatted the column to be a date and selected dd/mm/yyyy as the format. Great Only, it changes the date in any written form EXCEPT where dots are used. Is there a way I can format by validation or some such thing to error or replace "." with "/" (i.e dots with slashes.) Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
| How can I format a cell so date field only displays the Month? | Excel Discussion (Misc queries) | |||
| How can I defeat Excel's auto-reformating into date format? | Excel Discussion (Misc queries) | |||
Threaded Mode
