how to keep a date format stay on

sheldon 46 Reputation points
2021-10-27T16:24:16.757+00:00

Hi all,

I have a column filled in from a database in this format 1950-01-01. I want this look-like string format to stay on when it is referenced in another formula. But Excel always transform it into a SMALLINT like 28645. I know to put a in-front apostrophe can make it, but I have thousands of lines. Any way to make this task a little easier?

thank you very much in advance.

Sheldon

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,513 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,646 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,531 Reputation points
    2021-10-28T06:30:24.993+00:00

    Hi @sheldon ,

    Can you share, what formulas are these dates quoted by?

    Please check whether the formula below is helpful.
    =TEXT(A2,"yyyy-mm-dd")
    144356-capture74.jpg

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments