how do i change the default value of measure from points to inche.
how do i change the default value of measure from points to inches when
setting the width and hight of cells?
You don't. Excel uses only points for these measures
remove CAPS in email address
"yoyo4u" <firstname.lastname@example.org> wrote in message
> how do i change the default value of measure from points to inches when
> setting the width and hight of cells?
Row heights are measured in points. There are 72 points to an inch.
Th...defining accounts receivable default accounts
We would like the ability to have limitations on the accounts that can be
selected for accounts receviable for a sales order transaction or receivable
transaction. Currently you can select any account number for the RECEV trx
type. We would like to define allowable accounts receivable accounts to
avoid our current out of balance condition. This would limit the
possibilities of reasons for ar trade to be out of balance to gl. This is a
very hot issue at many clients in trying to reconcile ar to gl. This could
also apply to AP!!
This post is a sug...How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to
do it. Can anyone here please give me step by step primer. Thanks in
All I get is the graph of (1,2,............n) (x axis) against the n
values of either col A or B.
i.e 2 graphs instead of one.
(In the old Lotus this was so simple: select the column for the X axis
and then select the col for the Y and press enter, and you'd get the
Why is it so diff in Excel?
Select the entire range you want to graph such as a2:b44>insert>chart>>>>
I have read questions posted but not any answer for this issue.
In the Journal Viewer - the batch look up is defaulted showing the oldest
batch first rather than showing the most recent batch first.
Does anyone know how to change this to default to listing the most recent
Appreciate any help.
...Setting .doc default to .doc, not .dox
Operating System: Mac OS X 10.5 (Leopard)
How do i do this for all new documents?
> How do i do this for all new documents?
I meant .doc instead of .docx
Word> Preferences> Save, choose Word 97-2004 Document (.doc) from the Save
Word files as: list - just keep in mind that you'll be constantly working in
Compatibility Mode which will prevent the use of some of 2008's features.
On 4/23/08 7:50 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <dbdbdb@officeform...Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket
column on the Print Sales Documents screen? Currently when we open the
screen, we have to select which boxes to tick and since we always select the
same boxes we wondered if there was a way to have them default when the
screen is opened so we don't have to click each time. We want the "Picking
Ticket Per Site" box, the "Include Kit Components" box and the "Bin
Sequenced" box selected as default values.
You can accomplish this with a small VBA customization, b...Printing
Hope you folks can help me out with a strange one.
I have several worksheets formatted in exactly the same way as follows:
Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty
My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]
When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I m...Non-modal dialog pParent initialization (and warning C4355)
I have read several posts about "warning C4355: 'this' : used in base
member initializer list", and I understand about the object of 'this'
not being fully initialized, but that it is common 'safe' practice to
use this method to only save a pointer for future use..
OK, my question is;
What is the proper or best way to initialize a non-modal dialog?
I have used two methods:
CFooDlg::CFooDlg(CWnd* pParent /*=NULL*/)
: CDialog(IDD, pParent)
// pParent is not set here, See Create
BOOL CFooDlg::Create(CWnd * pParent)
pCV=(CMyBar ...Possible to Look Up Records by Initials?
I have a user who's telling me that prior to this weekend in CRM, she could
lookup user records by initials rather than typing in part of the name. I
don't see where that setting would have been marked in CRM. Has anyone else
heard of this? If so, how did you implement this type of search
Steps to recreate problem:
Account Owner field's magnifying glass
Assign to another user fields magnifiying glass
Look Up Records' Look For field = initials of user you're attempting to Find.
I doubt you can use the init...Default value for custom field?
How can I populate a custom field with a default value?
Specifically, I have a custom field "DisplayName"
associated with the Quote Detail object. I want initially
to populate this field with the value of the product name
field when a new product is added to a quote. The user can
then edit the DisplayName custom field if desired. The
DisplayName custom field will be used as the product name
on a Crystal Reports quote form.
...initial default column width
Is there a way to configure Excel 2000 so that when I create
a new Workbook or add a new Worksheet so that all the columns
have a particular width instead of the default 64 pixels?
Create the workbook exactly the way you want it, then save it as a
template with the name "Book.xlt" (no quotes) in you XLStart directory.
It'll be then used as the template for new workbooks.
Likewise, save a one-sheet workbook as a template, named "Sheet.xlt" for
the template for Insert/Worksheet.
In article <419E181F.6251D20D@nospam.net>, Bruceh <email@example.com&...Windows and Mac have two distinctly different units for column width.
Operating System: Mac OS X 10.5 (Leopard)
I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....How to assign unique number to column duplicates?
I need to assign a unique number to a set of duplicates all in one column in
so columnA will has about 9000 numbers, some of them unique, and others are
duplicates of 2-4 approx.
I used to conditional formatting to show which are duplicates, but need to
be able to assign a unique number to each set duplicates, that will be in
ColumnA ColumnB(unique ID)
Any ideas please? I don't know how to do programming, just form...Default Case View
Could someone tell me how I can setup default views for cases for
I know how to change the default view for all users, however I want to
make the view different for different users or groups (eg developers,
can someone tell me how this can be done in CRM 3.0 please?
What you are looking for is making the view private so that only certain
users can see it. This is done by opening the view in customization and
selecting sharing from the actions menu. By adding one or more teams, you'll
make the view private to those selected. In other ...Filter two columns with criterion applying to one or the other?
I am looking for a solution to the following filtering problem:
I have two adjacent columns, so using a filter for both of them is no
problem. But what I want to do and don't know how to do is this:
I want to filter for values greater than x (a certain number, in my
case 5000) in any of the two columns. I can filter both columns for x
greater than 5000 but that filters out more than I want because there
may be some cells with a value greater than 5000 in only one of the
Is there a solution to this problem (using Excel alone or an add-on)?
you can use th...Vlookup, multiple times in one column summing corresponding
I have a list that contains common invoice numbers that appear multipl
times in column A and need to use the vlookup function to find and su
the corresponding amounts in column B.
As you would be aware the following vlookup functio
=VLOOKUP(A3,DATA,2,FALSE) will only return the one amount once i
reaches a match and I need it to continue down the column and sum al
matching invoice numbers.
Column A Column B
145880 80.87 *
145880 54.09 *
The answer I�m looking to return is
It has to be a vlookup sty...Extract Values from a Column
I have a worksheet used to track time spent on various jobs. One column is for the JOB # while others are for descriptions, etc. I would like to have formulas or possible a macro (if necessary) to sum the time spent on different jobs. For example, say (for simplicity) that each row is equal to 1 unit of time. Then in this row I put 342 for JOB # 342. After the entire day I have worked on say 5 different jobs. I would like to have a cell that says "Total time spent on Job # 342" and then next to it a formula that would look at the column and count all the values that are equal t...Pivot Chart Bar Width
Is it possible to stabilize the width of the bars when using a Pivot Chart?
When there is very little data to chart - based on the values I select from page data pull-downs - the bars are really fat. Other times they are thin. I would really like to have a standard width.
The bars are based on a percentage of the spacing between categories.
If you have fewer categories, the bars get wider. If you decreased the
bar width (by increasing gap width on the Other tab of the format series
dialog), they'd be much further apart.
You can't adjust these automatical...HQ Reports
In the HQ report 'Work Orders - Detailed' one of the default columns is Order
#. I am hoping to enable the magnifying glass on this field that would take
me straight to the journal for that transaction. I do have my journals being
Is this a reasonable wish?
Can you point me in the right direction?
The worst words in business:
"We''ve always done it that way"
Stop Fishing for eMail.
DrillDownFieldName = "[Order].ID"
In the Order # column section.
Get Secure! - www.microsoft.com/security
You must be usi...Can I add more columns to a spread sheet or is limit 256 columns
I am trying to produce an Excel spread sheet with at least 370 columns in one
spread sheet but the limit seems to be set at 256. Is it possible to
increase this number?
Grit your teeth and wait for the next version of XL (12), and you'll have
all you need!<g>
Check out the new specs here:
Please keep all correspondence within the NewsGroup, so all may benefit !
"Pi...When Generating Report don't show columns which are empty
>I have project in MS access.
>In that project I am generating some reports for my company.
>Now In my form I have one combobox(PalletNo_combo)
>when I select an item from combobox and then click on search button then it will generate Report on search criteria.
>Now in that report I have 15-20 fields like
rtons,PartialCartons,ShippedDate,TotalQuantity,Shi ppedQuantity etc
>Now when Report gnerated I have column PartialCarton which is empty sometimes bcz of Null value inside it.
>So I don't want to show it in report...Smartlist Builder
I had created a Smartlist Builder based on Sales Process Hold Work and
History Table in Microsoft Dynamics GP. I had also created 2 GOTO functions
for this smartlist. One for Sales Process Hold Inquiry and Second to Sales
Transaction Entry. I had setup the Default Go To to point to Sales
I managed to correctly open up the Sales Document if I highlight the record
shown on the smartlist result and clicking on the Sales Transaction Entry
option on the GOTO button on the top right. But, if I double click on the
record, the Sales Transaction Entry screen does not a...Force exchange to use my default display name
Is there a way to force Exchange to chande the display name ???
Here's a exemple:
If our web site send a email to someone by relaying on the exchange
With the following information
Sender name: "Sales"
Sender email: firstname.lastname@example.org
To: Customer email adress
CC: Allan Tox
When I receive the copy of the email I want to see my display name of
email@example.com wich is Customer Service Paradox Security
and not from Sales...
Can you guys have a idea where I have to do my change on the Exchange server ?
Thank you...Form Default Value
The following is code for a UserForm. The Value of A1 in Sheet2 contains
the value that I want to use as the default value for this form. The value
of A1 is dynamic, and is the same as one of the values in the
How do I do this please.
Private Sub CombinedBankNames_Change()
boxvalue = CombinedBankNames.Value
Private Sub UserForm_Initialize()
Dim MyArray As Variant
'Where mylist is the named range
MyArray = Range("CombinedData")
CombinedBankNames.List = MyArray
This seemed to work ok:
Option Explic...Text to columns #2
Is there a way to have a worksheet automatically change to delimite
text to columns when it opens?
Thanks all, Vat
Message posted from http://www.ExcelForum.com
If I understand you correctly, simply record yourself doing it once and then
re-run the code in future
Microsoft MVP - Excel
"Vato Loco >" <<Vato.Loco.firstname.lastname@example.org> wrote in message
> Is there a way to have a worksheet automatically change to delimited