Forum Discussion
Solved
Disappearing Value
I have inherited an Excel estimating work book running on Windows 10, (Excel 2016) which I have to update to operate in different currencies, One of the sheets contains a price list which we wish to ...
- Thanks for that AL was in fact formatted as text so you were correct and the rest of the formula the result of multiplications. I had just solved it another way by appending & "" to the end of the formula. Many thanks for the help
I suspect that AL440 contains a text value that looks like a number.
Text values can be displayed spilling into the next column(s), but numbers (and dates) cannot.
When C50 contains £, the formula returns the value of AL440 itself. If this is text, as I suspect, this will spill into the next column. But if C50 contains another currency symbol, the formula returns the result of a multiplication, and that is a number, so it won't spill.
- Thanks for that AL was in fact formatted as text so you were correct and the rest of the formula the result of multiplications. I had just solved it another way by appending & "" to the end of the formula. Many thanks for the help