# Problem Displaying Incorrect Value When Printing Formula With Excel Set Function

**URL:** <https://forum.robusta.ai/t/problem-displaying-incorrect-value-when-printing-formula-with-excel-set-function/84>\
**Category:** Get Help\
**Created:** [April 22, 2022, 12:55pm UTC](https://forum.robusta.ai/t/problem-displaying-incorrect-value-when-printing-formula-with-excel-set-function/84 "2022-04-22T12:55:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sedef](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@sedef](https://forum.robusta.ai/u/sedef)\
**Post date:** [April 22, 2022, 12:55pm UTC](https://forum.robusta.ai/t/problem-displaying-incorrect-value-when-printing-formula-with-excel-set-function/84/1 "2022-04-22T12:55:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ilayda.ipar](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robusta.ai/ilayda.ipar/32/56_2.png) [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\
**Post date:** [April 25, 2022, 11:12am UTC](https://forum.robusta.ai/t/problem-displaying-incorrect-value-when-printing-formula-with-excel-set-function/84/2 "2022-04-25T11:12:48Z")

</div>

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