General cell

  • Thread starter Thread starter Unknown User
  • Start date Start date
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.
 
I think...
=text(a1,"mmm/yy") & " " & b1



Unknown said:
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.
Click to expand...
 
Hi,

You are loosing the date formating when you copy. 39722 is a date, which is
not formatted as a date. Select the cell and change the format to any date
format you want. Or select a cell the is formatted the way you want, and
click the Format Painter and highlight the cell(s) that are showing numbers
like those above.
 
Back
Top