Hi, i am trying to use external data in a simple formula but i get an error #VALUE!
'$10.30 is an example of the data i’m trying to use
if i copy the '$10.30 and paste as special unformatted text, i can use the data in a formula ok, but i need to reference the original data as its updated live.
i think the ’ before the 10.30 is causing the problem. which is only displayed in the top formula bar