How to add apostrophe for date

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
if its in A1
in b1 you can write

= "'" & a1 & "'"