Hi!

i have the current visable values

May-06
Jun-06
Jul-06
Aug-06

How do I insert ' (Quote sign) in front of dates in Col A so the underlying
values

01/05/2006
01/06/2006
01/07/2006
01/08/2006

becomes the visable values

'01/05/2006
'01/06/2006
'01/07/2006
'01/08/2006

Thanks In advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200609/1