Waqas Muhammad - * Beware of scammers posting fake support numbers here. I appreciate your patience and understanding. Also, make sure try going to ' SaveAs.'Īnd choose CSV UTF-8(Comma delimited) (.csv) You need to change your general region for it to work. If your language / region / locale uses comma (,) for decimal separation then Excel will save using semi-colons ( )Ģ. If it uses a dot (.) full stop or period, then it will delimit with commas (,).
Here are the rules Excel uses to determine how it saves CSV files:ġ. Then you need to verify the number separators in “Advanced …” > “General”. To change them, go to “System Preferences” > “Language For more details: Excelįormatting and features that are not transferred to other file formatsįor Mac OS the chosen value separator depends on your Region and your region's default number separators. Graphics, objects, and other worksheet contents will be lost.
I would like to share the information below with you: This file format (.csv) saves only the text and values as they are displayed in cells of the active worksheet. I apologize for all the trouble it has caused and sorry about your time.
