Troubleshoot:Convert numbers to date and time |
Convert numbers to date and time
Hello,
I have an Excel spreadsheet with data imported from another source and some of the columns show the date of the event in a format like a single number string.
For example - 201312101507 which is yyyymmddhhmm......I would like to convert this to show up as
Tuesday, December 10, 2013 - 3:07 PM.
Is there a formula that will do this? I have tried numerous things, and managed to get the "Text to Columns thing to extract and show the date, but can't seem to get the time part of the string.
Keys to the Problem Convert numbers to date and time
Download SmartPCFixer to Fix It (Free)
Check Windows System Requirements
This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:
Microsoft Windows Requirements :
- 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit)
If your computer meets the minimum requirements above, then continue on…
Another Safe way to Repair the Problem: Convert numbers to date and time:
How to Fix Convert numbers to date and time with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will scan your system. The errors will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Related: Can Not Install Update KB2509553 On OS Win XP.....many Times Attempted,Can We Have Multiple Users Using The Same Excel 2007 Template When They Login To A Terminal Server ?,Can Or Will The Dell Dock Harm My Computer?,Can't Connect To A Wireless Network With A Wireless Laptop,Can't Establish DDE Connection To Excel Starter 2010 From Word Starter 2010,Changing The Default In The Access Find And Replace Box,Charts In Excel - Show All Months,Cant Find Graphics Card After Reinstall Windows 7,Changing Sheet Names In Multiple Graphs Using VBA,Changing A Single Row Of Data Into Multiple Columns,Computer Not Starting In Any Mode - Normal Or Safe,Conditionally Change Backcolor Of Cell Depending On Date,Computer Said Operating System Corrupt And Shut Down, Now Will Not Start At All,Computer Freezes When Idle And I Have To Reboot,Computer Starts Up Slowly
Read More: Contacts Lists [Solved],Fast Solution to Error: Control Panel not working.,Troubleshoot:ContentEditable - Is there a way to make ie set the forecolor using a span tag instead of a font tag?,Troubleshoot:CoPilot interactive software from Abbott Laboratories,[Solution] Constant Crashes with PsychReport software,Changing Outgoing Mail Port Number to "587" as required to use Comcast E-Mail,Check box for sign off,Computer freezes when saving picture,Computer randomly freezes and restarts.,Computer won't wake from sleep with Windows 7 sp1 installed
