translation of part of a formula

re the formula below. How would one translate the bold and underlined section, in other words, what is the 0+ before LEFT doing?

=IF(E3="","",IF(AND(ISTEXT(LEFT(D3,1)),ISNUMBER(0+LEFT(E3,1))),D3,E3))

Thanks

Hi Blake7,


By adding 0 in left (e3,1), the formula is ensuring that the number is not left as text, thus actually it is converting the '5 into 5 i.e., converting a text digit to numeric.
Hope this helps.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi,

LEFT(E3,1) will return the first character of whatever is in E3 as a text string. Adding 0 to it attempts to convert it to a numeric value so that ISNUMBER can evaluate it as numeric if so.

Dom

perfect. I can relax again!