|
|
#1
06-12-2012, 04:35 AM
|
|||
|
|||
Date problem in excel 2007
I don't no if it is possible to convert numbers into a date, when i download a file from a tester it comes in a .csv file and when opened in excel the date is shown as 20120605 which is yyyymmdd but would like it to show dd/mm/yyyy
|
|
#2
06-12-2012, 04:40 AM
|
||||
|
||||
|
Hi,
Try this...
|
|
#3
06-12-2012, 05:10 AM
|
|||
|
|||
|
thank that worked
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| excel 2002, how to use a macro to find a field and add a date to the end of the row | Biggy | Excel Programming | 1 | 05-12-2012 03:03 PM |
 Date formating problem in EXCEL 2003
|
lyngio | Excel | 10 | 01-27-2012 03:37 AM |
| Conditional Formatting Problem Excel 2007 | namedujour | Excel | 6 | 08-04-2011 10:52 AM |
| Excel 2007 Chart title problem | skoley | Excel | 0 | 07-27-2010 06:23 AM |
|
Excel Date Alert?
|
Kelleigh | Excel | 1 | 12-05-2008 09:35 AM |
Windows XP 
Office 2007
Linear Mode
