Opening the CSV file in the Excel has two different appearances!

Jamal NUMAN · #5 01-19-2012, 02:14 PM

Quote:

Originally Posted by Colin Legg

Hi Jamal,

If you're opening the same file using the same method on the same PC, it's pretty strange that the delimiter would be honoured on some occasions but not others. It could possibly be due to the list separator not being set correctly in the Windows regional settings.

Yes, certainly. You can select column A > Data > Text to Columns. Then the method is very similar to the import wizard steps I mentioned before.

Thank you for the prompt answer Colin.

That's correct that i use the same method to open the file but not the same computer!

for the time being, I'm using my lab top, i'll check the setting of the "List separator" of the windows in the other PC and let you know.

is this the only reason for which i got the appearance shown in the screenshot 1?

regards

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening a file with FileDialogFilePicker	ACA	Word VBA	2	08-07-2011 12:43 PM
Issue when opening word file	msadiqrajani	Word	2	05-27-2011 08:11 PM
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
File gets hanged up while opening in excel 2007	nvsudheer	Excel	6	06-11-2009 05:47 AM
Opening MSO-2000 file in MSO-2003	w77	Word	0	04-21-2009 03:30 AM