Hi Mike,

Also - how to i limit data entry to letters only ?

If the cell is cell A1, use this custom formula for the validation:

=MAX(1*(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1)))))=0

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com