smartbuilder2k
New Member
- Joined
- Jan 18, 2005
- Messages
- 44
hi All,
this is an urgent requirement.I got list of more than 5000 rows.
i have to convert the date in text.
suppose if the cell contains "2005-11-01 18:07:40" then how can i show "NOV" adjacent to this cell.
Similiarly if cell contains "2005-10-28 14:08:05" then how can i show "OCT" adjacent to this cell.
I need this for every month.
Pls reply to it very urgent
Thanx & Regards,
this is an urgent requirement.I got list of more than 5000 rows.
i have to convert the date in text.
suppose if the cell contains "2005-11-01 18:07:40" then how can i show "NOV" adjacent to this cell.
Similiarly if cell contains "2005-10-28 14:08:05" then how can i show "OCT" adjacent to this cell.
I need this for every month.
Pls reply to it very urgent
Thanx & Regards,