Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I was using dates and wanted to copy only the day of the week in order to
analyse frequency of days of the week. Paste special only allows the copying of values, not of text. Eg. Tuesday gets copied as 38412 and 38440 (depending on the rest of the date) and all I want is "Tuesday" ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
Excel Save As... text with special characters | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Paste table from excel to word | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |