Hi

Firstly, Hello, my first post! So thanks if you can help

I would like to add a ' to a range of cells to ensure my previous
validation continues working.

Basically. Even though the cells are formated in Text format,
validation isn't working for some reason without the 'xxxx in the
cell.

does anyone know how to add this?

I have tried concatenate, but i then have to go down and f2, enter in
all the cells??

Would really appreciate your help.


--
cclambie
------------------------------------------------------------------------
cclambie's Profile: http://www.excelforum.com/member.php...o&userid=29135
View this thread: http://www.excelforum.com/showthread...hreadid=488546