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 



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 :

How to Record Audio Directly to USB Flashdisk on Ashley Remix-802 Mixer

The Ashley Remix-802 mixer is an audio mixer that features direct recording to USB. However, the recording process might not be immediately intuitive since there isn't a clear "record" button. Here are the steps to record audio directly to USB on the Ashley Remix-802 mixer: Recording Steps:  1. Format the Flash Drive: Format your flash drive with the FAT32 file system using a laptop or computer. 2. Add an MP3 File: Insert at least one MP3 file into the flash drive. This is necessary for the mixer to read the flash drive and enable the recording process. 3. Plug in the Flash Drive: Plug the flash drive into the USB port on the Ashley Remix-802 mixer. If the flash drive is recognized, the mixer will start playing the MP3 file, and the display will show that music is playing. 4. Start Recording: Press and hold the Play/Pause button for a few seconds until the display shows "rec." This indicates that the recording process has started. 5. Stop Recording: To stop the ...

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.