Convert formula to text in Excel

Learn Academy Feedback
1

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

Screen Shot 2020-09-02 at 5.05.37 PM
Screen Shot 2020-09-02 at 5.05.37 PM934×549 148 KB

Can anyone know how to solve it? thx

Screen Shot 2020-09-02 at 5.04.27 PM

2

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

3

Hi @mason_wong,

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

Regrads,
Neelima.

4

Hi @mason_wong,

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

5

Thx It works

1 Like
6

Thank you for the alternative solution

7

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