Thread: General cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Unknown User[_2_] Unknown User[_2_] is offline
external usenet poster
 
Posts: 13
Default General cell

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.