Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
Using Excel 2007 and W7. Have a spreadsheet I created that is saved as a CSV File. Some cells have text in them, which I have a single set of quote marks around to define as Text. e.g., "Bob" It does show in the extreme left of the cell, as text should. If I look at the Cell with "Format Cells", it comes up with "General". But I don't know if opening this command is supposed to actually show the Format of the cell. Is it ? Anyway, if I now look at the spreadsheet with Notepad, all the cells I put the single set of quote marks around now have three sets. e.g., "Bob" now shows in Notepad as """Bob""" Why ? Is this correct ? (Should I have had the single quotes kept, but ALSO formatted these text cells definitively as TEXT ?) Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
For Claus Busch: From OP Re Quote Marks. | Excel Discussion (Misc queries) | |||
How do I force quote marks when exporting to a csv? | Excel Discussion (Misc queries) | |||
Quote Marks Through VBA | Excel Discussion (Misc queries) | |||
How to keep quote marks for CSV in excel | Excel Discussion (Misc queries) | |||
How do you look for quote marks? | Excel Programming |