I need VB code...
The following value appears in a cell:
2/4/2014 9:52:43 PM
I want to capture just the date 2/4/2/14 and paste it in another cell on another sheet and change the format to Rotate Text Up.
I need VB code...
The following value appears in a cell:
2/4/2014 9:52:43 PM
I want to capture just the date 2/4/2/14 and paste it in another cell on another sheet and change the format to Rotate Text Up.
Last edited by bishoposiris; 02-23-2014 at 07:32 AM. Reason: Solved
As dates are stored as numbers of days since an arbitrary point in the past, you can trim off the time by using the INT function to loose the decimal portion. Format the cell containing the formula with Format cells setting number format to date and rotation as appropriate.
Martin
I appreciate your response but I need the vb code to make this happen.
Try this.
Assumes that the original date in in A1 and the output cell is E1Please Login or Register to view this content.
Awesome! Thanks for the help!
Last edited by bishoposiris; 02-23-2014 at 07:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks