Excel functions

[SNOWBALLCHAN]

Use a function : =IF(AD3="","",VLOOKUP(AD3,Table!$E$2:$G$450,3,0)), return
value in cell AE3 e.g. = 03

My problem: Try posting this value to another cell using this function
=IF(AE3<10,IF(AE3="","","50-0"&AE3&"-"&AB3&"-790-50026-0000"),IF(AE3="","","50-"&AE3&"-"&AB3&"-790-50026-0000"))

The return value always truncated the preceeding zero if I do not use the
last function

I I know this is not proper. Any good suggest from the Pro thanks.

 

[Douglas J. Steele]

I'd suggest asking this in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.