Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi to all
I have this problem I'm working with a text file, I have a macro who opens the text file, and make some changes in the file, the the macro saves the file, under text format, so the problem is this: In the cell A6 I have this text: where(substr(text1,1,2)) So when excel saves the changes the cell A6, is saved like this: "where(substr(text1,1,2))" because the commas in the text, I want to save the cell value in the way it is (with commas), and no with quotation marks. I don't want the quotation marks, I try with to saved like commas separator text file, but it doesn't work either. I hope you can help me. Thanks alot Be good The force be with you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comma in Function Argument name treated as separator | Excel Worksheet Functions | |||
How to use comma as list separator instead semicolon? | Setting up and Configuration of Excel | |||
thousand separator conversion from dot to comma | Excel Discussion (Misc queries) | |||
Comma separator for custom Currency | Excel Discussion (Misc queries) | |||
thousands comma separator in VBA | Excel Discussion (Misc queries) |