Yes exactly, the numbers are coming to Excel as text. When you select the
"print to file / Excel" (3 excel options) in each case a dialog box comes up
with a few options you can select, but none of them are anything like "keep
numbers as numbers". Perhaps there is such an option in the Gateway Export
utility, but I was asked about the print preview option to go to Excel since
they don't have access to the full RBase version.
Karen
-----Original Message-----
From: [email protected]
To: [email protected]
Sent: Tue, Dec 29, 2020 3:08 pm
Subject: RE: [RBASE-L] - Report output to Excel - FOUND IT!
#yiv5457776504 #yiv5457776504 -- _filtered {} _filtered {} _filtered {}
_filtered {}#yiv5457776504 #yiv5457776504 p.yiv5457776504MsoNormal,
#yiv5457776504 li.yiv5457776504MsoNormal, #yiv5457776504
div.yiv5457776504MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv5457776504
a:link, #yiv5457776504 span.yiv5457776504MsoHyperlink
{color:blue;text-decoration:underline;}#yiv5457776504 a:visited, #yiv5457776504
span.yiv5457776504MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv5457776504 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv5457776504
span.yiv5457776504EmailStyle18 {color:#1F497D;}#yiv5457776504
span.yiv5457776504SpellE {}#yiv5457776504 .yiv5457776504MsoChpDefault {}
_filtered {}#yiv5457776504 div.yiv5457776504WordSection1 {}#yiv5457776504 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 type, i.e. keep them as
number so you do not have to make the conversion in Excel? I seem to recall an
option to do this but maybe it is in the EXPORT utility rather than reports. L
Javier, Javier Valencia, [email protected]: 913-829-0888C:
913-915-3137 From: 'Karen Tellef' via RBASE-L
[mailto:[email protected]]
Sent: Tuesday, December 29, 2020 9:30 AM
To: [email protected]
Subject: 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!!! In case
anyone wants to know how to turn those markers on/off, you pick "file /
options", Formulas tab: Karen -----Original Message-----
From: 'Karen Tellef' via RBASE-L <[email protected]>
To: [email protected] <[email protected]>
Sent: Tue, Dec 29, 2020 9:24 am
Subject: Re: [RBASE-L] - Report output to ExcelTony: 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 cells. Yet my =SUM still isn't
working. Here's my sum below: If I type a "2" over one of those 1s, the
sum shows 2: Karen -----Original Message-----
From: Tony IJntema <[email protected]>
To: [email protected]
Sent: Tue, Dec 29, 2020 9:15 am
Subject: Re: [RBASE-L] - Report output to ExcelKaren,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)Select the exclamation mark and then a right
mouse clickYou should see the menu as below (sorry in Dutch)The second option
is convert to number.Hope this helps. Tony Op 29-12-2020 om 15:35 schreef
apstock:
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 change the
formatting of the highlighted cell.
On 12/29/2020 9:19 AM, 'Karen Tellef' via RBASE-L wrote:
Steve: can you do a print-screen of that? I've highlighted the numbers and
cannot find the option box that you're talking about (perhaps we're on
different versions). Since the list allows pics now, post the print-screen to
the list in case someone else can use this very helpful tip! Karen
-----Original Message-----
From: Steve Johnson <[email protected]>
To: [email protected]
Sent: Mon, Dec 28, 2020 8:28 pm
Subject: RE: [RBASE-L] - Report output to ExcelKaren, 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 diamond with an ! point), choose convert to number and it
will work. I have monthly reports where I have to do the same thing. One
thing to note, if your spreadsheet is more than one page and the columns shift,
particularly on a subsequent page, tinker with the report object placement for
the range of cells that moved. I also usually have blank rows of cells from
the page break that have to be trimmed off using ‘delete row cells’ in Excel.
Then the columns are contiguous and then I convert (or the staff does) the
range of cells within a column to a number so they can use the =sum formula as
needed. Steve Johnson From: 'Karen Tellef' via RBASE-L
[mailto:[email protected]]
Sent: Monday, December 28, 2020 5:45 PM
To: [email protected]
Subject: [RBASE-L] - Report output to Excel Haven't played around with this in
a while, but someone requested instructions. If I have a report to the screen
and do a "print to file" picking Excel (either 2003 or xlsx), it formats pretty
well. If I bring up Excel and want to insert a sum by using the =SUM(....) it
shows up as 0. If I do each individually as a cell (such as: +A1+A2+A3) then
it adds up the numbers, but not when I do a =SUM. Obviously using the + isn't
good if I want to add up hundreds of lines. Is this an Excel issue? I tried
a couple things: 1. I left my =SUM in the spreadsheet. If I type over any of
the numbers, my sum works (but only on the numbers that I typed over) 2. If I
highlight some of the column of numbers and "format cells" and change it, it
doesn't work. For example, I had a column of integers and did a "format cells"
to change it to a number with 2 decimals, and it leaves the column untouched.
Other individual calculations work (such as +B1/A1) just not the =SUM.
Anyone getting that to work? Karen --
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/397078517.3912595.1609195474881%40mail.yahoo.com.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/005201d6dd8a%24581e3b90%24085ab2b0%24%40sprintmail.com.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/670373004.4031006.1609251582146%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/a9c3a281-da4a-970f-fe8f-d69e65176350%40sbcglobal.net.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/56170e10-f6d9-357a-5e35-77256203ec0f%40cio-bv.nl.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/500400194.4056033.1609255443325%40mail.yahoo.com.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/827918818.4050337.1609255827317%40mail.yahoo.com.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAMSsZZPN63JEl67ds0M9eGEBAAAAAA%3D%3D%40vtgonline.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/86766185.4155887.1609277048839%40mail.yahoo.com.
