I am writing some data from SAS to excel using DDE. Excel is making some assumtions and displaying the data in the cells in its own assumed formats. how do I instruct excel to consider everything as text for all the columns?
Currently I am using this, but looks like it is not working.
I am using this after values are put into excel.
put '[FORMAT.NUMBER("@")]';
example: I have some value which start with dollar sign and I don't want excel to put in currency format. Like wise same thign for decimals. I have values like 8.,10.2 and so on. Excel is changing the formats.
Currently I am using this, but looks like it is not working.
I am using this after values are put into excel.
put '[FORMAT.NUMBER("@")]';
example: I have some value which start with dollar sign and I don't want excel to put in currency format. Like wise same thign for decimals. I have values like 8.,10.2 and so on. Excel is changing the formats.