Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell Format from General | Excel Worksheet Functions | |||
Cell changes from General format to Scientific | Excel Worksheet Functions | |||
Format: General - Text - General | Excel Worksheet Functions | |||
?? call it: general cell() ?? | Excel Discussion (Misc queries) | |||
How to stop a general format cell | Excel Worksheet Functions |