• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

i need the final excel sheet in text

carolyn

New Member
The dates column need to be in the text format for importing the file but still appear dates, when the dates are copied from another excel sheet of format "date"-- after changing the format of the entire excel sheet to text they become numbers...

I need them as dates --plz help:)
 
Excel dates are actually numbers. You can convert the numbers to proper dates in text format using TEXT formula. Assuming date is in column A, write in column B, =TEXT(a1,"dd-mmm-yyyy") to get date in dd-mmm-yyyy format.
 
Back
Top