U
Unknown User
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.
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.