Not Recognized Format
I've written large workbooks with excel xp, but at home I am using excel
2000. Is there any way to convert the xls file format that xp uses so I can
work with the spreadsheet at home?
All versions of Excel since 97 use the same file format, so no
conversion is necessary. If you can't open the file, it is
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"SKLwater" <firstname.lastname@example.org> wrote in message
> I've written lar...Change default font format in Excel
I have an existing workbook with cell text entries in regular black font. I
want to make a number of additional entries in various cells in this
workbook, and I want all my text entries to be a different font format (bold,
red). Is there a way to do this automatically without highlighting each
entry I make and manually changing the cell format? Thanks.
Copy the code below, right-click on your sheet tab, select "View Code" and paste the code in the
window that appears.
MS Excel MVP
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Cou...Date format issue when submitting from a userform to a spreadsheet
I have a userform that I've generated which routes dates onto a spreadsheet
based on the users input. I am having a bit of a frustrating time with the
dates, it would appear that in the process of moving the date from the
userform to the spreadsheet some dates are switched/transposed. I'll give an
example. If someone enters 09/02/2004 on the userform excel seems to look at
09 and assume it is a month and transposes the dates to 02/09/2004(this does
not appear to be a US/UK format issues as I have already gone down that
road). However, if the date 13/09/2004 is entered i...Question On Fields
What is the (Microsoft desciption)difference between the
SIC field and the Industry Code field? To me they seem
like a duplication.
According to the Deployment Manager descriptions of attributes:
SIC - Standard Industrial Classification code for the Account
industrycode - the type of industry with which the account is associated...
Hope this helps!
"Shauna Koppang" <email@example.com> wrote in message
> What is the (Microsoft desciption)difference between the
> SIC field and the...Pivot Table formatting #6
When I format my pivot tables I have "preserve formatting"
checked under "PivotTable Options", and "Autoformat Table"
unchecked. Even so, I either lose portions of my
formatting, or different formatting is applied when I
refresh. Does anyone know what I am doing incorrectly or
have any other suggestions?
Other things to try -- if they don't work, you could record a macro as
you refresh and reformat the pivot table. Then, run that when you want
--Instead of selecting the cells to format the numbers, right-click the
field but...Count unique values
I've some problems to count unique items (Invoice #) in a pivot table. There
is the default solution "Add-a-new-calculated-column" as mentioned on
http://contextures.com/xlPivot07.html#Unique, but in my case, it doesn't
My problem is, that these values aren't in a Excel worksheet; it's a
external data source - a SQL-Select via DAO/ADO. Because of that, I don't
have the possibility to add a new column. Another reason is, that the pivot
table should always be dynamic: Group over this field, group over another
field - and always show the number of unique...Web Query question
I am trying to download stock options through the following vba code, however
i am having problem with separator between "m" field which is month and "s"
field which is stock symbol, I appreciate any help i can get,
With ActiveSheet.QueryTables.Add(Connection:= _
I think you are mising (at least) one quote?
> I am trying to download stock optio...Custom cell formatting
I need to create a custom format for a series of cells that will begin like
I can't figure out what the code character is fora volitile potentially
Can anyone help me??
something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character
"MDavison" <firstname.lastname@example.org> wrote in message
> I need to create a custom format for a series ...Formula Question #18
I have built a workbook in which I have inserted a formula to tell me whether
the contents of a supply bin needs replenishment or not. The formula I used
is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to see
what parts have been used, which becomes a new sheet in the workbook.
Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
back through the workbook to count whether that same part needed
replenishment on consecutive previous days. If it has, then the latest
worksheet will report the number of days that ...Auto formatting features: How do I align page numbers in publicati
I've got a problem with my publication. I can't align even page numbers to
the left without automatic moving the odd numbers to the left as well? Can
someone help me?
> I've got a problem with my publication. I can't align even page numbers to
> the left without automatic moving the odd numbers to the left as well? Can
> someone help me?
You need to create a two-page master rather than a one-page master. What
version of Publisher are you running?
Ed Bennett - MVP Microsoft Publisher
...Exchange 2003 Question #3
I have upgraded from Exchange 5.5 and notice that I miss the feature where I
can clean/delete mail based on certain criteria from users mailbox via the
System Manager. Is this feature still available in Exchange 2003, If so,
where is it? Thanks.
You can use ExMerge to remove emails based on certain criteria (ie.
attachment name, subject, etc).
"KA Kueh" wrote:
> Dear all,
> I have upgraded from Exchange 5.5 and notice that I miss the feature where I
> can clean/delete mail based on ...AD/Network design question
I have a 2 sites which users come and go from. These sites have 2 different
network ip domains (192.168.1.x and 192.168.2.x). Users need to be
authenticated using the same user id and password at both sites. DC/GC is at
192.168.1.x and is a SBS 2003. Server at 192.168.2.x is Server 2003.
When the server at 192.168.2.x is connected via vpn to 192.168.1.x all is
How do I get the server at 192.168.2.x to act as a AD/DC when it’s not
connected to 192.168.1.x ?
I think you will run here into the limitations of SBS :-(
@ SBS experts : ...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...formula: counting presence
I have to count presence of employees from sheets between START and END,
which is stored in G9 cell. I think it should be something like:
=SUM(IF(START:END!G9="present"; 1; 0)), but this one returns #REF and I
don't don't why.
Try these from a post of mine today.
Put the sumif on each sheet with an indirect reference to d12 of the master.
=sum(sheet1:sheet21!a2) where a2 in your sumif formula.
One way to put=SUMIF(B:B,Sheet1!D12) on each sheet is to select all>type the
formula in the cell desired>after the error msg>delete from the ...Formatting
I've always used MS Word as my email editor in Outlook. Is this possible in
Nope. I'm afraid that's only possible using Outlook.
In WLM you have to use the built in editor. Is there anything in particular
that's lacking from the built in editor that you're looking for?
"jrchambe" <firstname.lastname@example.org> wrote in message
> I've always used MS Word as my email editor in Outlook. Is this possible
> Live Mail.
In a Column 'A' sales Commission is calculated and resulta
is as 250, 200, 300, 330.
I wanted to format a cell with a Blinking colours where
value is 100 to 250, 250 to 300, 300 to 350 and 350 &
please help to format my sheet ... thanks
Getting your cells to "blink" is not in the standard Excel formats
What you want would require some extensive programming, certainly, ou
of my capabilities.
However, there are some great things you can do with Excel'
Let's say in column A you have numbers that are the result of formu...newbie question
Excel help says it should be a tab under tools, but I can't see it in
I would appreciate any help.
You must first load the Solver Add-in through Tools>Add-ins.
Gord Dibben MS Excel MVP
On Sat, 03 Nov 2007 07:46:34 -0700, email@example.com wrote:
>Excel help says it should be a tab under tools, but I can't see it in
>I would appreciate any help.
On Nov 3, 10:56 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> You must first load the Solver Add-in through Tools>Add-ins.
> Gord Dibben MS E...Z Report Customer Count vs Hourly Sales
My Z report shows customer count of 380 and hourly sales total of 384. Why
the difference? This happens all the time.
Your glass is:
Half-Empty : Do folks at register forget to ask "Is there anything else I
can help you with?"
Half-Full: Your impulse items at POS are working -- better late than never!
> My Z report shows customer count of 380 and hourly sales total of
> 384. Why the difference? This happens all the time.
OlyBikes Locally-Owned B...Date Format turn to Year
I tried to convert the date to YEAR and then the year plus 25 Years
=Year(A1) I'm getting the result 1900 instead of 1965.
I tried to add 25 years later to 1990 from 1965.
Your help would be much apprecated.
What's in A1?
Are you sure it's a real date?
> I tried to convert the date to YEAR and then the year plus 25 Years
> =Year(A1) I'm getting the result 1900 instead of 1965.
> I tried to add 25 years later to 1990 from 1965.
> Your ...Opening and formating a CSV file?
Could someone remind me how to handle CSV files please? I had assumed
the Text Import Wizard would pop-up when I use File|Open, but the data
goes straight into the worksheet. (Presumably because it is not
'delimited'?) Without the Wizard at my side, how do I get each
comma-separated field in its own column?
Terry, West Sussex, UK
Try renaming your .csv file to .txt
Terry Pinnell wrote:
> Could someone remind me how to handle CSV files please? I had assumed
> the Text Import Wizard would pop-up when I use File|Open, but the data
> goes straight into the worksheet...Problem access variable in On Format
I'm using Access via Office XP Pro.
I am trying to format the Zip Code on the detail line of my report.
I have tried the following lines of code in both the On Format event and the
On Print event:
If len([PostalCode]) > 5 Then
if len(Me.PostalCode) > 5 Then
In both events and either code, I receive the error message:
Access can't find the field 'PostalCode' referred to in your expression.
If I put "PostalCode" as the source of the report's control...Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be
missing something here. Some data on vendor numbers changed. Let’s say IBM
used to have a vendor number 12345 and now it’s vendor number is 56789. I
can identify IBM as IBM, but I really want to use the number, not the name.
Should I set up a table that ties the numbers together, so that Access knows
12345 = 56789? Or, should I do some kind of Update Query and change all
incidences of 12345 to be 56789? Or, is there some other, method, like a
‘best practices for missing data’?
...Formatting Cells in Excel 97
Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?
Appreciate any form of advice, thanks!!
I replied in the programming group. Are you seeking a programming
answer? It's usually best to only post to one group, and include the
remark "Please tell me if I should ask this in another group."
On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <firstname.lastname@example.org> wrote:
>Sorry if I sound real stupid b...Custom CRect Question
I have a custom rectangle class that inherits from CRect:
class CCustomRect : public CRect
CCustomRect(RECT* source, CPoint pt, COLORREF rgb);
void Update(RECT* r);
Inheritance has worked well until I found myself needing to create the
RectBase function (above) to return the rectangle dimensions.
CRect does not seem to have any methods that can be called to return the
base class's RECT value.
I could take CRect::Size and construct a rectangle to return, but this seems
a bit much.
My...Excel link update question
I need to maintain an excel workbook which contains a lot of links to
workbooks. Since the linked workbooks change every week, I need to
the links accordingly. For example, a cell with formula
!A10" will be changed into "='[sep_4.xls]sheet1'!A10". I tried to do
Find/Replace. However, the link is updated every time it is changed.
The link updating takes a couple of seconds. So it may take a hour
to finsh it for a workbook with thousands of links. Could anyone tell
to shut down the link updating when...