人気ブログランキング | 話題のタグを見る

Convert cells (pasted from another application) to date format [Solved]

Convert cells (pasted from another application) to date format

I've copied tasks from MS Project into Excel.
Once copied over, the Start and Finish date/times show as a custom format (ddd m/d/yyyy h:mm AM/PM) as they should. But when I try to change to a different date format nothing happens so I'm unable to sort these
tasks by the Start date.
I've tried paste special>add and putting a zero into a blank field and copying the format but none of these work.
I have over 1000 tasks and it's not possible to type in every single date/time.

Solutions to the Problem Convert cells (pasted from another application) to date format

Download Error Fixer (Free)

With Col_A containing pseudo-dates in the form of: ddd m/d/yyyy
This approach will eliminate the day reference and convert the remaining date-text to actual dates:
• Select the single column range of dates
• Data.Text-to-Columns
...Check: Delimited...Click: Next
...Check: Space........Click: Next
...Select the first column (the days)...Check: Do not import column
...Select the second column (the dates)...Check: Date: m/d/y
...Click: Finish
 
That will convert this: Sun 1/15/2012
To this date: 1/15/2012
Format the end result into any date format you want.
 
Does that help?

  1. Access the files on your computer via MY COMPUTER
  2. Under the C: drive, access the WINDOWS folder
  3. Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
  4. Delete any files within this download folder.
  5. If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
  6. Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Another Safe way to Repair the Problem: Convert cells (pasted from another application) to date format:

How to Fix Convert cells (pasted from another application) to date format with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Can We Exclude Zero Values In Datasets From Displaying In Pie Chart Graphs?,Can We Disable The Charms Bar In Windows 8?,Can Imessaging Be Used To Talk To Someover Over Seas Via Video,Can't Clear Print Queue (phantom Document?),Can You Print Two Or Three Spreadsheets On The Same Page. All Spreadsheets Are In The Same Workbook.,Cant Get IE To Pull Webpages When WEP Settings Are Appliedl; Can Only Access The Homepage????,Cant Open A Microsoft Excel File Directly From My Desktop,Cells Shifting On Save In Excel.,Change The Decimal Point To A Comma,Change Pages In My Documents,Computer Freezes During Video Or When Openining Browsers. Have To Hot Reboot Every Time.,Computer Wont Shutdown After Upgrading To Windows 8.1,Computer Hung After Wiindows Update,Computer Freezes Randomly In Windows 7.,Computer Will Not Select Desktops After Upgrade From Vista To Windows 7
Read More: Troubleshoot:Cookies: Receive message that cookies need to be enabled Error,Constant, abrupt restarts or BSODs (sometimes due to nwifi.sys) [Solved],How to Fix Error - Convert date to just year??,Troubleshooting:converting a number from millions to thousands Error,Control panel taskbar function repair Tech Support,Cell population from list depending on selection in previous cell,Changing auto open of pdf files with Adobe,Conditional format and blank cells,computer freezes works only in safe mode and BlueScreen Error BCCode: 116,Computer shuts down when it goes into sleep mode
by RpcServerIsUn6 | 2016-09-23 17:30