Problem Displaying Incorrect Value When Printing Formula With Excel Set Function

Get Help
1

Hello, I’m having a problem displaying incorrect (#VALUE! ) values ​​when using the Excel Set Formula function. Can you help me?

2

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”.