On Thu, 28 Sep 2006 11:07:09 GMT, "FIRSTROUNDKO via OfficeKB.com" <u15639@uwe
wrote:

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

Difficult without VBA.

However, you could:

1. Format/Cells/Number/Custom Type: dd/mm/yyyy

or use the formula in an adjacent column:

=TEXT(A1,"dd/mm/yyyy")


--ron