Forum Discussion
Transpose function returns #VALUE
Kayllen Attache your file after removing the @'s.
Kayllen Not sure what you are trying to achieve, but when I opened your file there were several @-signs in the formula in AF320. Removed these and then cleared all the other cells below and to the right.
Then numbers appeared in the range AF320:AN328. Is that what you need?
Hi, Riny_van_Eekelen
I am not sure what @ signs you are referring to. I have attached a screenshot of what I am seeing in the formula bar.
Kayllen Attache your file after removing the @'s.
Thank you.
Could there be a setting in my excel that could be causing this issue of the @ signs that I am not inputing nor can i view them in the formula?
Kayllen Not sure. Not an expert one why and when the @-signs appear. What Excel version are you on?