RE: [sqr-users] SQR output in .csv file

[don.barclay@srs.gov]

Bob was half way there.  If you use the tab as your delimiter, you can 
then successfully use ="23,124.300" and excel will treat it as a text 
value, retaining the comma and trailing zeros.

I would imagine that you are already naming the file with an .xls 
extension if you are able to open the file in excel by double clicking. 
Otherwise, you would have to have the proper file association on any 
computer that may need access to the file.

> Hi Srikanth,
> 
> I suggest using tab as your field delimiter rather than comma.  It is
> interpreting the comma in your value as a field delimiter - so use a
> different delimiter.  Excel works just as well recognizing Tab for
> field, Carriage Return (chr 13) as record, as it would with comma.
> 
> As to your second question (how to preset formatting for a cell so as to
> show 3 significant digits even with trailing zeros), I don't know the
> answer, but you should look in help references to see how to preset
> formatting so that a csv file will open with preferred formatting.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users