General cell

[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.

 

[Dave Peterson]

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

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.

 

[ShaneDevenshire]

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.