1. Use the format brush to copy it from the correct cell to the new
cell.
2. Use Formaty/Cell/number and pick the format you want. Jan'06 is a
standard date format.
3. Copy the Jan '06 cell into the new cell
4. There are probably more ways. ed