{"id":1034,"date":"2015-11-09T07:05:11","date_gmt":"2015-11-09T07:05:11","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=1034"},"modified":"2015-11-09T07:07:46","modified_gmt":"2015-11-09T07:07:46","slug":"excel-converting-date-to-text","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/excel-converting-date-to-text\/","title":{"rendered":"Excel – Converting Date to Text"},"content":{"rendered":"

There may be times where the excel date is displayed as number like one below. In such case the date can be converted to string as follows<\/p>\n

\"\"<\/p>\n

Two things<\/p>\n

    \n
  1. The J column is aligned to Left which tells there is some custom format done over the cells<\/li>\n
  2. On selecting the cell and when you check the drop down at top it shows Custom<\/li>\n<\/ol>\n

    The Column K represents the actual value of Cells in J by making it to text format. Now to convert the Column J to Text use this simple excel formula<\/p>\n

    \r\n =TEXT(A1,"DD\/MM\/YYYY hh:mm:ss")\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
    There may be times where the excel date is displayed as number like one below. In such case the date can be converted to string as follows Two things The J column is aligned to Left which tells there is some custom format done over the cells On selecting the cell and when you check… Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76],"tags":[],"class_list":["post-1034","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/1034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=1034"}],"version-history":[{"count":4,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/1034\/revisions"}],"predecessor-version":[{"id":1039,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/1034\/revisions\/1039"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=1034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=1034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=1034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}