| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help...Date converting to USA from UK when running Macro !!!
padmaster Wrote: Sorry, the code is part of the macro....this macro is to convert a excel file into a csv file and it is the dates within the files tha are being changed from a UK format to a USA one... Any help is appreciated.... Paddy Sorted !!! Range("c:c").NumberFormat = "dd/mm/yyyy" Where c:c is the range This ensures the format is correct in the macro... Thanks for all your help -- padmaste ----------------------------------------------------------------------- padmaster's Profile: http://www.excelforum.com/member.php...fo&userid=3643 View this thread: http://www.excelforum.com/showthread.php?threadid=56199 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting hijri date to gregorian date | Excel Discussion (Misc queries) | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Converting a year date into a specific day date | Charts and Charting in Excel | |||
| converting date from a textbox to a date format | Excel Programming | |||
| Converting a string date into a Excel Date | Excel Programming | |||
![padmaster[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
