Skip to main content

Can't Open CSV file Correctly in Ms Excel

CSV (comma separated value) is extension file that used to store the data tables in plain text format. To open this type of file we usually use the Ms Excel.
If you have the CSV file, but can't be opened correctly in Ms excel ( no table, and difficult to read), here is the solution.

It is usually caused by the difference of standard number format, between CSV file and the Computer.
To resolve this problem in Ms Windows


• Click Start -> Control Panel -> Language And Region
• Click on Additional settings (at the format tab )




• In the Columns : List separator, change from , (comma) to ; (semicolon) or from ; (semicolon) to , (comma)




• Click OK
• Now open the CSV file.


See Also :
• How to Protect Ms Excel File using Password 
• How to set Autoresponder, auto reply / Out of office assistant in Gmail. 
• Driver for VMware Accelerated AMD PCNet Adapter For Windows 7 
• How to know who doesn't follow you while you follow them on Twitter 
• Faster way to open Blogspot Pages 
• How To Resize Picture (reduce file size) Using MS Outlook 



Labels:

Popular posts from this blog

How to Enable Hyper Terminal In Windows 7

Hyperterminal Windows 7. Windows 7 Hyperterminal. Hyper terminal is used for data communication via serial port com or TCP/IP Winsock. Unfortunately on Windows 7, Windows 8 and Windows 10 we can't see anymore, even though many of us who still need it, and it is not the solution if we have to go back to Windows XP. The solution :
Read more

Vaio stuck on loading screen after upgrading to Windows 10

My Sony Vaio laptop model : VPCCA16FB with originally using Windows 7 operating system, then now I already upgraded it to Windows 10. All drivers are already installed for each device, everything is OK with this Windows 10 OS. The only problem is:  when I switch the laptop on or restarting it, after vaio logo appears then it stuck with blank screen and it takes about 2 minutes. After that, then it continues to loading Windows. After I googling about the problem, I am not only the one, other people also have the similar problem with their laptops. The cause is in the Ultra Low Power State (ULPS) system. ULPS is a feature or mode in hardware (graphics card) designed to save power by reducing energy consumption to very low levels. Now the problem is solved. If you have the same or similar problem, maybe this below step will help you too.
Post a Comment
Read more

How to deny access to a drive in Windows 10

How to disable access to drives in Windows.  One of ways to  make disable access to drives in Windows (all Windows, Windows 10, Windows 8, Windows 7, also Windows server.. ), you can use Group policy editor . Below are  the steps: 1. Press Windows + R  (to open Run command ), write gpedit.msc at Run column, then hit Enter or click OK.
Read more