Convert formula to text in Excel

Hi all,

I have list of name that contains formula in Excel. Every month, the date will be automatically changed via formula. When I tried to get the list of name, I can’t get the correct date. I can only get XXX202000, but it should be XXX202008

Can anyone know how to solve it? thx

Screen Shot 2020-09-02 at 5.04.27 PM

Have you tried using excel application scope and read range inside of that?

Hi @mason_wong,

Try this below link to convert formula to text in excel it might be helpful, if it works mark as solution.


Hi @mason_wong,

The problem in your excel formula. The formula take value from B3 cell instead of B2. So check your formula.

Thx It works

1 Like

Thank you for the alternative solution

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.