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)
Need admin approval -- Azure webapp message
Challenge encountered : Today one of my colleague could not access a webapp that I have created in our Azure Tenant. The error is as follo...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des... -
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...
No comments:
Post a Comment