Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

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.

Site: Microsoft Office (Excel, Word) forum - OfficeFrustration - General Discussion (site profile, domain info officefrustration.com)
Title: General Discussion
Url: http://www.officefrustration.com/forumdisplay.p...
Users activity: 3 posts per thread
Forum activity: 55 active threads during last week
 

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:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Jacob Skaria
5
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?
David Biddulph
5
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...
Luke M
4
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...
Dave Peterson
4
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...
Pete_UK
4
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...
eduardo
3
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
Manny
3
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...
CLR
3
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]_-;_-*...
Etz99
3
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"...
Bob I
2
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::

Microsoft Office (Excel, Word) forum - OfficeFrustration
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?
Thread:  Show this thread (2 posts)   Thread info: change cells contents from vertical to horizontal Size: 562 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: change cells contents from vertical to horizontal :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
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: ...
Thread:  Show this thread (6 posts)   Thread info: Is there a way to Auto sort or save a sort? Size: 2,560 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Is there a way to Auto sort or save a sort? :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
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 ...
Thread:  Show this thread (3 posts)   Thread info: EXCEL: Separating data from 1 cell into multiple cells Size: 696 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: EXCEL: Separating data from 1 cell into multiple cells :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
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
Thread:  Show this thread (4 posts)   Thread info: =today() less one month Size: 488 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: =today() less one month :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
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 ...
Thread:  Show this thread (2 posts)   Thread info: cell character limit Size: 1,048 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: cell character limit :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
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 ...
Thread:  Show this thread (4 posts)   Thread info: Hyperlinks were lost Size: 1,633 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Hyperlinks were lost :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
 

Hot threads for last week on General Discussion::

No active threads for last week.