'How to convert number to date in excel?
I have column with value 44134 which is formatted as date time(yyyy/mm/dd) to 2020/10/30.
I am trying to convert this to have 2020/10/30 as value so that I can use in formulas. For this I tried to put this into a new column using formula
Text(G2,"YYYY/MM/DD")
but this gives popup error "there is problem with the formula". There must be something really simple I am missing here. Excel has no problems formatting it right from the format menu but format doesn't change the underlying value. How do I get around this?
Solution 1:[1]
It looks like I needed to check the delimiter.
As suggested in the comments
'"&TEXT(G2|"YYYY/MM/DD")&"' worked for me in the end.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | minusSeven |