Any Excel experts out there?

[Laura PourMeADrink]

My cells:

<Date: 01/01/2012>


I want:

<01/01/2012>

[cyberswede]

1. Maybe create a custom date format?

Instructions here:
http://office.microsoft.com/en-us/excel-help/format-a-date-the-way-you-want-HA102809474.aspx

[Laura PourMeADrink]

3. thanks. I actually figured out how to do it...and it was simple as pie

all I had to do was to "find" "Date:" in each cell and replace it with nothing.

[NRaleighLiberal]

2. highlight the cells - right click, format cells, choose text as an option?

[Laura PourMeADrink]

4. I will try that, thanks. I got rid of the text label "Date:" but now I can't

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]

7. When you did the global search-and-replace to get rid of "Date:", make sure

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]

9. thanks P. Gotta rebuild my worksheet - was on the remote server and it went down

I need to tape a huge sign up. Save work every two minutes.

[ConcernedCanuk]

5. It appears you like tomatoes

.
.
.

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]

6. Try this

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]

8. thanks. Speaking of pasting value....I don't really understand

why sometime I get all these paste options (including value) and sometimes only one - plain old paste.

[Paulie]

10. Depends on where the paste is from

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]

11. It was a host download I converted to csv and then pasted it into a blank excel workbook. so once

it was in excel, thought I'd have the paste options

[Paulie]

12. Did you open the csv in excel?

Try notepad and see if its different.

[OriginalGeek]

14. If I'm misunderstanding what you were doing, just ignore this lol..but

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]

13. There are differences there.

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.