strip characters out of a field

[IT]

Is it possible to write a formula to do the following:

Take

02-Jan-03 07:47:48

and strip out the time to make the field look like

02-Jan-03

Thanks, Matt

 

[JohnI]

IT,

We need to know if this is a text field or a date field.

If it's a text field, it's simply = left(A2,9)

If it's a date field, then = int(a2)
or just format, cells, select "dd-mmm-yy"

will probably work.

regards,

JohnI