Share this post! | Vote this! |
|
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")
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")
0 comments:
Post a Comment