G
Guest
I have two columns with date (an effective and expiration date), for a pivot table I need to combine these two into one statement "5/1/2003 to 5/1/2004" I created a formula, example (=A1 & " to " & b1), the result is "37742 to 38108
How do I get the # to show as a date
I know that if you add an ' in front of a date it shows as text. I have several thousand records and would need to add it to each field. A way to add the ' to all the records would also be an acceptable way for me to go. I just don't want to have to input the ' in each field manually
Any help would be appreciated.
How do I get the # to show as a date
I know that if you add an ' in front of a date it shows as text. I have several thousand records and would need to add it to each field. A way to add the ' to all the records would also be an acceptable way for me to go. I just don't want to have to input the ' in each field manually
Any help would be appreciated.