Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving characters in csv
How do I save a character (check mark) in a csv file converting from excel.
It changes to a ü. What can I do to save it as a check mark? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving characters in csv
You will not be able to save the check mark character to a text file, only
characters in the Windows ANSI character set will get exported to the CSV file. To see what characters would get saved, in a blank spreadsheet enter the number 33 through 255 in column A and in column B enter the formula =CHAR(A1). Copy the CHAR formula down to the last number to see the corresponding character for each ANSI character value. -- Kevin Backmann "Dee" wrote: How do I save a character (check mark) in a csv file converting from excel. It changes to a ü. What can I do to save it as a check mark? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving characters in csv
What happens when you re-import the CSV file into excel?
Remember that since CSV files don't keep track of any formatting, you'll have to give the cell (column of cells???) the same Font format to see the same symbol? Dee wrote: How do I save a character (check mark) in a csv file converting from excel. It changes to a ü. What can I do to save it as a check mark? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges - what characters are (or are not) allowed in the nam | Excel Discussion (Misc queries) | |||
How can I control the length of characters a code will return? | Excel Discussion (Misc queries) | |||
Formula to replace invalid filename characters | Excel Worksheet Functions | |||
Remove varying amounts of space characters | Excel Discussion (Misc queries) | |||
Help - Can't directly input Japanese characters into cell | Excel Discussion (Misc queries) |