Re: [RBASE-L] - Report output to Excel - FOUND IT!

column headers, break headers, totals, etc.  None of that would come with a temp table without significant programming.  Karen -Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 4:34 pm Subject: Re: [RBASE-L] - Report output to Excel - FOUND

Re: [RBASE-L] - Report output to Excel - FOUND IT!

- From: javier.valen...@vtgonline.com To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 3:08 pm Subject: RE: [RBASE-L] - Report output to Excel - FOUND IT! If I understand correctly, you have number columns/variables in R:base that are coming to Excel as text? Is there a feature to keep the t

RE: [RBASE-L] - Report output to Excel

From: 'Karen Tellef' via RBASE-L Sent: Wednesday, 30 December 2020 02:24 To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Report output to Excel Tony: I've seen those green markers before, but in this case (I'll repeat my print-screen here) for some reason there is no green marker on these c

Re: [RBASE-L] - Report output to Excel - FOUND IT!

ther than reports. L   Javier,  Javier Valencia, pejavier.valen...@vtgonline.como: 913-829-0888C: 913-915-3137  From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Tuesday, December 29, 2020 9:30 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Report output to Exc

RE: [RBASE-L] - Report output to Excel - FOUND IT!

to turn those markers on/off, you pick "file / options", Formulas tab: Karen -Original Message- From: 'Karen Tellef' via RBASE-L To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 9:24 am Subject: Re: [RBASE-L] - Report output to Excel Tony: I've seen those green mark

Re: [RBASE-L] - Report output to Excel - FOUND IT!

: Re: [RBASE-L] - Report output to Excel - FOUND IT! Tony mentioned those little green markers and that rang a bell!  That used to annoy me seeing those things so I turned that option off!  I turned the option back on, I get the green markers, and can do the convert and my sum works fine

Re: [RBASE-L] - Report output to Excel

If I type a "2" over one of those 1s, the sum shows 2: > > > > Karen > > > > > -Original Message- > From: Tony IJntema > To: rbase-l@googlegroups.com > Sent: Tue, Dec 29, 2020 9:15 am > Subject: Re: [RBASE-L] - Report output to Exce

Re: [RBASE-L] - Report output to Excel

my sum below: If I type a "2" over one of those 1s, the sum shows 2: Karen -Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 9:15 am Subject: Re: [RBASE-L] - Report output to Excel Karen, You can do it this way: Select all figure

Re: [RBASE-L] - Report output to Excel - FOUND IT!

on/off, you pick "file / options", Formulas tab: Karen -Original Message- From: 'Karen Tellef' via RBASE-L To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 9:24 am Subject: Re: [RBASE-L] - Report output to Excel Tony:  I've seen those green markers before, but in

Re: [RBASE-L] - Report output to Excel

--Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 9:15 am Subject: Re: [RBASE-L] - Report output to Excel Karen, You can do it this way: Select all figures you like to convert (the green marker up left is showing that the number is stored as text

Re: [RBASE-L] - Report output to Excel

helpful tip! Karen -Original Message- From: Steve Johnson To: rbase-l@googlegroups.com Sent: Mon, Dec 28, 2020 8:28 pm Subject: RE: [RBASE-L] - Report output to Excel Karen, You have to convert the column numbers displayed (which are in text format) to numbers. Formatting the cells

Re: [RBASE-L] - Report output to Excel

al Message- From: apstock To: 'Karen Tellef' via RBASE-L Sent: Tue, Dec 29, 2020 8:35 am Subject: Re: [RBASE-L] - Report output to Excel Karen, Highlight the cell you want to convert to numbers. To the left of the top most cell there will be an excel symbol which one can select to ch

Re: [RBASE-L] - Report output to Excel

Johnson To: rbase-l@googlegroups.com Sent: Mon, Dec 28, 2020 8:28 pm Subject: RE: [RBASE-L] - Report output to Excel Karen, You have to convert the column numbers displayed (which are in text format) to numbers. Formatting the cells using the format option does not work. Highlight the range

Re: [RBASE-L] - Report output to Excel

-Original Message- From: Steve Johnson To: rbase-l@googlegroups.com Sent: Mon, Dec 28, 2020 8:28 pm Subject: RE: [RBASE-L] - Report output to Excel #yiv4116875070 #yiv4116875070 -- _filtered {} _filtered {}#yiv4116875070 #yiv4116875070 p.yiv4116875070MsoNormal, #yiv4116875070

RE: [RBASE-L] - Report output to Excel

Karen, You have to convert the column numbers displayed (which are in text format) to numbers. Formatting the cells using the format option does not work. Highlight the range of column cells (not the header) and to the left of the top cell in the option box, (looks like a small