By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,075 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

export xls to csv

P: 1

I wanna export Excel xls to CSV comma delimited, but if my file have decimal number sach as 40,25 in column AC,AD and AE. How put '' '' to protect the decimal in these three columns?

Many thanks

Jan 17 '12 #1
Share this Question
Share on Google+
2 Replies

P: 144
When you "SaveAs" cvs, it should automatcally create a "comma separated" filem meaning each cell is followed by a comma. Your numbers would look like like this when you open the new file in a text editor: 12.25,hello,"hello,dolly",etc. The numbers are already protected. If there's a comma inside the field then the value (string) is surrounded by " ". The other fields are open for interprtation by whatever import app you might use.

Why are you exporting it? If your importing it somewhere else, you may be able to import the xlsx without converting it first.
Jan 17 '12 #2

Expert Mod 15k+
P: 31,492
I was going to answer but it seems it's been perfectly covered already. You may just want to thank the poster and select post #2 as Best Answer.
Jan 18 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.