|
|
|
|
#1
07-24-2015, 09:52 AM
|
||||
|
||||
A quick way :
Select the first column Data - text to column - Click Finish immediately ( don't change anything in the wizard) Do the same for the 2nd range Now you can custom format as desired
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 'Monday to Friday' Date calculation help needed | ballst | Word | 10 | 12-16-2014 09:51 AM |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
 changing date format in Bibliography field
|
elly111sk | Word | 3 | 07-25-2012 06:54 PM |
|
Correct Format needed
|
TonyB | Mail Merge | 3 | 05-03-2011 01:10 AM |
| Help needed using the serial number date with sumifs - whole office is stumped | FraserKitchell | Excel | 3 | 01-06-2010 12:24 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode