Jul 18 2020 06:56 PM
Jul 18 2020 06:56 PM
I'm having a problem with the new function LET.
I created a formula that writes down number's values to letters. For this, I assigned 40 names to formulas in the function. Initially, it worked perfectly, but whenever I copy the formula (in current or a new workbook), close and reopen the file, it's triggering an error. The formula disappears and leaves only the last calculated result in the cell.
If anyone knows what happened, I'd appreciate any tip.
Jul 19 2020 09:49 AM
Looks like a bug, I'd suggest you to send a frown through File->Feedback.
By the way, number to text formula with LET() you may find in discussion here https://techcommunity.microsoft.com/t5/excel-blog/announcing-let/ba-p/1233572
Aug 21 2020 09:31 AM
Hi @Sergei Baklan:
Thanks for your reply!
I went through the number to letter formula in the discussion and found it very helpful!
I rewrote mine (for Spanish numbers) in a similar way, but I keep getting the same error.
I already wrote to Excel Feedback and I am still waiting for their response.
Sad not to be able to enjoy the formula.
Aug 22 2020 01:07 PM
Perhaps you may submit the file where this function returns an error, it'll be easier to check what is wrong.
The only point, from the time of publishing abovementioned sample of the forum there was introduced the change in function - it doesn't support dots within names any more. Other words, with name as H.txt you'll have an error, use Htxt instead or any other name without the dot. Correct formula is in attached file. But that's another issue, not as in initial post.
Aug 26 2020 02:58 AMSolution
For your information, I also sent a frown. People at Microsoft can reproduce the bug, hope will be fixed one day.
Please note this function is in Beta mode, that means bugs could appear in some scenarios, plus function behaviour on time of general availability could be slightly different from what we have now. That's normal process, so far we use the function (as any other beta ones) on our own risk, even if such risk is relatively small.