How to add apostrophe for date

Closed
pinky - Mar 30, 2010 at 11:12 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 30, 2010 at 11:42 AM
can anyone tell me how to add apostrophe at Beginning, end for date in excel

i have date 2009-01-07 10:25:59 i want this as '2009-01-07 10:25:59'

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 30, 2010 at 11:42 AM
if its in A1
in b1 you can write

= "'" & a1 & "'"
0