• Changing Dates to Text (Excel 2000)

    Author
    Topic
    #392028

    I did not see a format function in Excel. I want to create a formula to change a date to text, or to preserve the date formatting when I use the field in a pivot table. Is this possible?

    THanks for any assistance.

    Viewing 0 reply threads
    Author
    Replies
    • #702317

      Check out the Text() function in help. I think that it is what you are after.

      Peter

    Viewing 0 reply threads
    Reply To: Reply #702317 in Changing Dates to Text (Excel 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel