|
More site info...
General Discussion | Forum profile
|
|
Forum profile page for General Discussion on http://www.officefrustration.com.
This report page is the aggregated overview from a single forum: General Discussion, located on the Message Board at http://www.officefrustration.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "General Discussion" on the Message Board at http://www.officefrustration.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on General Discussion:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
55
|
1,674
|
6,143
|
|
Post:
|
106
|
4,304
|
18,315
|
|
|
General Discussion Posting activity graph:
|
Top authors during last week:
user's latest post:
change cells contents from...
Published (2009-11-19 16:52:00)
Select the data to be copiedCopySelect target cellRight clickPasteSpecialselect 'TransposeOK If this post helps click Yes --------------- Jacob Skaria "GailH" wrote: I need to copy from one workseet the values in cells that are arranged vertically into another worksheet and the values need to be arranged horizontally. Can this be done? If so, how?
user's latest post:
How can I expand print area to...
Published (2009-11-19 15:48:00)
So I think you are telling us that the "fit to 1 page wide and 1 page tall" has worked correctly, in that if you incease the print size it will overflow to a 2nd page. Glad to hear that it's working correctly. (You might, of course be able to get a bigger print if you swap between landscape and portrait, if you have chosen the inappropriate aspect for the shape of your print area.) -- David Biddulph...
user's latest post:
cell character limit
Published (2009-11-19 16:36:00)
The actual limit is 32,767 characters. Of this, only 1,024 will display in a cell. (info from "Excel specifications and limits" in XL help file) Due note that when you set the format of a cell to text, this is when the 256 limit kicks in. Simply change the formatting of the cell to "General" and then you'll be good to go. -- Best Regards, Luke M *Remember to click "yes" if this post...
user's latest post:
Create a flat file in Excel
Published (2009-11-19 14:38:00)
You could change the windows list separator (in the regional settings applet in the control panel) to the vertical bar (just temporarily). Then save the file as a delimited file. Or maybe you could create a formula in another cell: =a1&"|"&b1&"|"&c1&.... And drag down. Then copy that column and paste into notepad and save the file from notepad. GF08 wrote: I need to...
user's latest post:
Different perspective of RANK
Published (2009-11-19 03:22:00)
I'm away for a few days from tomorrow, so if you do reply then your response is likely to be lost when I get back. Assuming that you do only have 3 groups, then you could do this: =IF(K11=1,B11&IF(OR(K12=1,K13=1)," and ",""),"")&IF(K12=1,B12&IF (K13=1," and...
user's latest post:
=today() less one month
Published (2009-11-19 16:34:00)
Hi, =TODAY()-30 then do custom format for the cell using mmmm "Jim" wrote: Hello, In a cell I would like to return last month, October. What is the formula for this? Thanks Jim
user's latest post:
How can I expand print area to...
Published (2009-11-19 15:14:00)
Changing the percentage changes the print size and the width iexpands to the whole page as I want it. However, it kicks some rows to the 2nd page instead of fitting everything in one page. It didnt do what I want and that is have the whole page used without printing on a 2nd page. "David Biddulph" wrote: Look at what percentage Excel has calculated, then increase it. Or are you trying to tell us that increasing the...
user's latest post:
formula to make currency...
Published (2009-11-19 15:03:00)
Maybe this will give you a directon..... Sub CheckCurrencyFormat() If Selection.NumberFormat = "$#,##0.00" Then Selection.Offset(0, 1).Value = "US Dollars" Else If Selection.NumberFormat = "[$£-809]#,##0.00" Then Selection.Offset(0, 1).Value = "English Pounds" Else If Selection.NumberFormat = "_-* #,##0.00 [$â¬-813]_-;-* #,##0.00 [$â¬-813]_-;_-*...
user's latest post:
All Hyperlinks have changed the...
Published (2009-11-19 04:25:00)
I have a situation where this has occurred with my file of Hyperlinks. I use several folders of data on my network drive (G:\) which changed to local (D:\). Changing my Hyperlink base would be difficult here due to different folder locations on the G:\ drive. Am I correct? Also Dave Peterson, when I use your =hyperlink formula it seems I have to copy and paste the path and add \'filename.xxx", "Simple Name"...
user's latest post:
Create a flat file in Excel
Published (2009-11-19 15:26:00)
How about SaveAs CSV and then open the file in NotePad and do a Find Replace , for | ? GF08 wrote: I need to create a flat file in Excel using the pipe delimiter | as element, and carriage return line feed as line delimiter. How do I do this?
|
|
|
|
Latest active threads on General Discussion::
Started 1 week, 4 days ago (2009-11-19 16:52:00)
by Jacob Skaria
Select the data to be copiedCopySelect target cellRight
clickPasteSpecialselect 'TransposeOK
If this post helps click Yes
---------------
Jacob Skaria
"GailH" wrote:
I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?
Started 5 months, 4 weeks ago (2009-06-05 14:44:00)
by Eric
I have tried this several times in Excel 2007 and it does not retain the sort
criteria. The macro method is how I did it with Excel 2003. Surprisingly,
the sort macros I used from 2003 still actually work. However, I can't
create new ones. Microsoft needs to create a "Save Sort" function.
"Bob I" wrote:
record a macro and run it each time.
Dorlynne Harris wrote:
...
Started 1 week, 4 days ago (2009-11-19 16:26:00)
by eduardo
Hi,
Highlight the column, Text to columns, Delimited, next, check only the Other
box and copy your | in the box beside it, next, finish
"HeatherJ" wrote:
I have thousands of cells in a report with information that I need to
separate into different cells.
Ex. one cell: Arch | South | All Points | Extreme
I need an automated way to get each of the 4 names ...
Started 1 week, 4 days ago (2009-11-19 16:23:00)
by Luke M
=TEXT( EDATE(TODAY(),-1),"mmmm")
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Jim" wrote:
Hello,
In a cell I would like to return last month, October. What is the formula
for this?
Thanks
Jim
Started 1 week, 4 days ago (2009-11-19 16:36:00)
by Luke M
The actual limit is 32,767 characters. Of this, only 1,024 will display in a
cell.
(info from "Excel specifications and limits" in XL help file)
Due note that when you set the format of a cell to text, this is when the
256 limit kicks in. Simply change the formatting of the cell to "General" and
then you'll be good to go.
--
Best Regards,
Luke M
*Remember to click "yes" if this ...
Started 1 week, 6 days ago (2009-11-17 15:43:00)
by John Keith
On Mon, 16 Nov 2009 22:13:02 -0800, Etz99
wrote:
Hi All,
I have Microsoft Office 2007 and I have a spreadsheet that contains hundreds
of links to forms to each individual row created. I last saved my file last
Thursday and today I opened my file only to find my Hyperlinks that were
associated to a G:\ Drive (network) have now showing my local D:\ as the
Hyperlink. No files are ...
|
|
Hot threads for last week on General Discussion::
No active threads for last week.
|
|
Size: 562 bytes
