The DU Lounge
Related: Culture Forums, Support ForumsAny Excel experts out there?
My cells:
<Date: 01/01/2012>
I want:
<01/01/2012>
cyberswede
(26,117 posts)Laura PourMeADrink
(42,770 posts)all I had to do was to "find" "Date:" in each cell and replace it with nothing.
NRaleighLiberal
(60,031 posts)Laura PourMeADrink
(42,770 posts)sort by date...even though the cells are formatted as dates. It puts all the 01's (Jan) together, despite the year.
How's the weather today in NC? We are having a bit of a reprieve in TX. It was 105 Friday. No matter how much I water my plants they still look very very sad.
petronius
(26,608 posts)you also included the space after the ":".
IOW, the search should have been for "Date: " and not "Date:"
If there's a leading space, I don't think Excel will recognize those as dates no matter the cell format, and will offer to sort 'A to Z' rather than 'Oldest to Newest'...
Laura PourMeADrink
(42,770 posts)I need to tape a huge sign up. Save work every two minutes.
ConcernedCanuk
(13,509 posts).
.
.
Check this out
http://www.democraticunderground.com/discuss/duboard.php?az=view_all&address=246x10250
That's one plant I grew years ago - more pics and info at the link above.
CC
Xyzse
(8,217 posts)Highlight the Column you want to make for the date.
Right click choose option "Format Cells"
Go down to Custom
In Custom there is something that says "Type"
Place in <mm/dd/yyyy>
That should be a sortable date type.
Good luck!
Also, please remember that if you are just going to paste the information from another cell to your new formatted column, make sure you paste value so that it doesn't get rid of the format.
Laura PourMeADrink
(42,770 posts)why sometime I get all these paste options (including value) and sometimes only one - plain old paste.
Paulie
(8,462 posts)If the source is text, HTML, rich text. Copy from excel to excel its rich text as it also has the formatting. Same for HTML from say a web page; Copy text from a paragraph you'll end up with text but copy something with a hyperlink it's different.
Clipboard is a bit complex for something that appears simple; DDE or dynamic data exchange hides a lot of complexity.
Laura PourMeADrink
(42,770 posts)it was in excel, thought I'd have the paste options
Paulie
(8,462 posts)Try notepad and see if its different.
OriginalGeek
(12,132 posts)Instead of pasting a csv into excel, I would open a blank workbook and import the csv (Data tab, get external data, from text - and then find the csv file in the browse dialog). During the importing process you can tell excel that you want to format the date column as dates.
Xyzse
(8,217 posts)To explain.
1 - Paste - Regular, it pastes the value, the format and everything about it.
2 - Past Format - Takes the format of the copied cell and places it to format the cell you want. So basically, you have a nice format for a date and you want that format to be the same for another value, you use this.
3 - Paste Values - Takes the information in the copied cells and pastes it just as if you typed it. You use this to copy something and put it in to a column with a format that you want to keep.
Hope that helps.