question

sheldon-9882 avatar image
0 Votes"
sheldon-9882 asked emilyhua-msft answered

how to keep a date format stay on

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-excel-itprooffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

Hi @sheldon-9882,

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.



capture74.jpg (21.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.