|
|
#5
10-10-2020, 01:51 PM
|
|||
|
|||
Hi,
I see you have that formula in a new column immediate to right of my date column. if I copy that to my date column I get Sep-71 when I type sept 1972, and I get 15 apr 69 if I type a full date 15 April 1969. the formulA ceases to exist in the cell just typed in,as well it might as I have then superceded it. It needs to pull the data in from the date column. It is giving me a year 1969 or a month year Sept 1971 or a full date 23 Nov 1991 so thats working. How can I have this so I havent a third column as its made the data 3 columns wide per subject now., and I have two columns with dates in so a double vision confusion going on. DBenz 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mail merge field mistakenly interpret text format as date format | alan6690 | Mail Merge | 0 | 09-02-2020 01:54 AM |
| Create Field That Displays Date+30, Office 2007 | Papote | Word | 6 | 10-09-2016 02:47 PM |
 Date format but with Jan Feb mar etc how is this done ?
|
DBenz | Excel | 3 | 12-21-2014 05:00 AM |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
| date format | gsrikanth | Excel | 1 | 12-28-2011 05:06 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode