If you have a date in a cell, when you try to use it as it is for example in concatenation, the date gets converted to a number and does not retain the date format.
In order to retain the date format and still be used as text -- the formula that can be used is TExt(datecell, "dd-mm-yyyy")
Subscribe to:
Post Comments (Atom)
-
40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attent...
-
Did you know that you can connect to your Power BI Desktop Model from Sql Server Management Studio (SSMS)? If not, this blog post is fo... -
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
No comments:
Post a Comment