Gentlemen, thanks for your help. Those cells are actually formatted as "custom". Formatting to "text" didnt work. Shaun's idea gave me a #VALUE error,.................I'll keep persevering, thanks again,

Paul