Hello, I’m having a problem displaying incorrect (#VALUE! ) values when using the Excel Set Formula function. Can you help me?
The source cell data format of the formula used by the Set to Excel cell should be in the supported format.
For example, in the formula =TEXT(G2, “mmmm”) set in Excel, it is desired to have the month name of the date written in cell G2. However, using the date format (yyyy-MM-dd) written with a “-” (hyphen), the set formula appears in the cell incorrectly.
In cell G2, the format “9/17/2021 6:02:19 PM” should be used instead of “2021-09-17 18:02:19”.