I think...
=text(a1,"mmm/yy") & " " & b1



Unknown User wrote:

The date column is general cell with showing date (mmm/yy) but formula bar is
showing actual date (mm/dd/yy), when i want to copy the date column to
another column with other column (eg. Item) context but the formula copy cell
is show Item 39722.

Example:
Column A(Date) B(Item) C(This is my actual want to copy from column A
& B)
Oct/08 Apple Oct/08 Apple
but the coloum C showing 39722 Apple. How to change the 39722 to Oct/08?
Please advise.

Thank you very much.

--

Dave Peterson