Patti, Use the Gateway Wizard to generate a spreadsheet export where you can specify the columns and formatting and save the export as a *.rgw file. Next time you can just specify the file you saved with all the saved formatting. Works very well. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Wednesday, March 02, 2016 1:47 PM To: [email protected] Subject: [RBASE-L] - problem exporting decimals into Excel Workbook I sent this yesterday with my Excel attachment, but I don't think anyone ever got it. So I'll try again without the attachment. _____
From: Patti Jakusz <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, March 1, 2016 10:49 AM Subject: problem exporting decimals into Excel Workbook Hello, I have to export data into Excel Workbook format, producing multiple spreadsheet pages. My file has two columns (MomAge and BabyAge) that are numeric (5,1) values. When I open the resulting spreadsheet, I find those two columns formatted as a Number with zero decimal places and the result has been rounded. I tried exporting to a regular Excel Spreadsheet and it works fine. But that doesn't give me what I need. How can I get the decimals to show up without having the data-entry clerk go in and reformat the columns in Excel? Here is the syntax for one of the sheets: GATEWAY EXPORT xlsw HealthyStartHeadSt.xlsx + SELECT HVSiteName, MomName, MomAge, + ProgStart, ProgEnd, BabyFNM, BABYLNM, BabyDOB, DaysProg, BabyAge + from HEADSTWork order by MOMNAME whe EXIT2DAT is not null + OPTION COL_NAMES ON + |TAB_NAME Dismissed and > 2.5, < 4.0 Patti
