Hi,
Appologies if this has been answered before, but I couldn't seem to find it in a search.
I pull data from a software package in to excel which as part of product order lines gives me dimensions as 'yyy' x 'zzz'. I can change the 'x' symbol to a * for the formula to work out the area, but I'm unsure how to add an '=' to the front of the text line to make it a working formula. I have tried using the formula ="=" & I2 but it shows it as a normal text string rather than it calculating the formula. I am sure it is something really simple that I've overlooked, but it's driving me crazy having to click each cell (there are usually 80+) to enter the = sign to the beginning of the entry.
Many thanks in advance
Mike
Bookmarks