Re: Creating Excel File from SQR (numeric text)

[Pam Lantzy <plantzy@UAMAIL.ALBANY.EDU>]

I just discovered a solution earlier this week myself.
When write the .csv datafile in sqr if you know the field is going to be numeric
you can string  an equal sign with double quotes around the field
Example:
="0001234"

This indicates in excel that its a numeric and not to strip the leading zeros.

One problem with this though is if the user resaves this .csv with the same name
in excel this notation is gone and when you reopen the .csv again in Excel the
leading zeros will disappear.

Pam

Dominick LoGiudice wrote:

> I am trying to create a .csv file from SQR.
> My problem is fields like ssn which could have a leading 0.  No matter what I
> try it
> when I open the .csv file in excel it drops the leading 0.
> "012345678" becomes 12345678.
> How do you write out numeric text fields?