Karen What I have done in the past was to open Notepad then highlight the column of numbers and cut and paste them into Notepad. Highlight and copy them from Notepad paste them back to Excel column.
Buddy Sent from my iPhone > On Dec 29, 2020, at 10:24 AM, 'Karen Tellef' via RBASE-L > <[email protected]> wrote: > > > 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 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 Excel > > Karen, > You can do it this way: > <clcnoclakjhblcol.png> > 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 click > You should see the menu as below (sorry in Dutch) > <fpbbojbjhnbcgmgb.png> > 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 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 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. > <fpbbojbjhnbcgmgb.png> > <clcnoclakjhblcol.png> -- 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/735D9507-9C76-4A6E-A335-E7E0484948D8%40comcast.net.
