My formula is as shown - =IF('[production sheet
template.xls]1'!$Q$14=212,'[production sheet template.xls]1'!$S$14,0) - My
problem is that I need to use 00212 instead of 212 in the formula but when i
use 00212 excel truncates it to the above and the correct value is then not
resolved in the cell. I am ok with formatting the cell itself to show the
correct value, its the formula itself that truncates and then does not use
the leading zeros. Can you help please?

"Dave Peterson" wrote:

Maybe you can use "00123" in your formula. =if(a1="00123", ...

Or if 123 is in a cell, =if(text(a1,"00000")....

But if that reference is just 123 and formatted to show leading 0's, you'll
still want to use the numeric value 123--not the text "00123".



Paul wrote:

When entering an 'IF' formula to locate information on another spreadsheet
the formula truncates the leading zeros in my argument. The information I
want is tied to a reference with leading zeros i.e. 00123 and so on. How can
i set the formula to accept the leading zeros to locate the correct
information?

--

Dave Peterson