Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Friday, April 6, 2012 10:27 PM
cant seem to get this to work. Im trying to add single quotes to a column with dates in it. Ive been trying to use ="'"&a1&"'" to do so and i get the quotes, my problem is that its converting it to a 5 digit number associated with the date in excel. i dont know how to convert it back other than formatting the cells which hasnt worked no matter what combination of formats i try. anyone have any ideas?
input 01-01-2012 formula ="'"&a1&"'" output '40909'
All replies (2)
Saturday, April 7, 2012 3:11 AM âś…Answered | 1 vote
On Fri, 6 Apr 2012 22:27:41 +0000, wondergoat7777 wrote:
>
>
>cant seem to get this to work. Im trying to add single quotes to a column with dates in it. Ive been trying to use ="'"&a1&"'" to do so and i get the quotes, my problem is that its converting it to a 5 digit number associated with the date in excel. i dont know how to convert it back other than formatting the cells which hasnt worked no matter what combination of formats i try. anyone have any ideas?
>
>input 01-01-2012 formula ="'"&a1&"'" output '40909'
You have to format the date value within your text string:
Either of the following:
="'" & TEXT(A1,"m/d/yyyy") & "'"
or
=TEXT(A1,"'m/d/yyyy'")
Ron
Monday, April 9, 2012 3:31 PM
thank you! i figured that out about an hour after i posted this and forgot to check back here. Thanks anyway!