Excel Regional Date Format Options
A client of ours in NZ is complaining that date format options for English
(New Zealand) have changed from older versions of excel (they are using 2003)
Some of their spreadsheets have dates formatted as dd-mmm-yy, mmm-yy and
dddd,dd,mmm but these options do not exist anymore.
Is there anyway to add options to this list without using the custom format
I just compared the Excel 97 and Excel 2003 built-in date formats and they
are mostly unchanged. 2003 has a few more but I don't think there were any
subtractions. The formats dd-mmm-yy and mmm-yy are righ...MS Excel 2003 cannot auto calculate formula, need to press F9 each time
I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.
what is the likely reason ? it was running fine 2 weeks ago.
any advise is greatly appreciated.
Tools>Options>Calculation tab, check Automatic
Microsoft MVP - Excel
<email@example.com> wrote in message news:firstname.lastname@example.org...
| I don't know w...How to Change Value of Active Control
I'm writing a routine to change the value of any Active Control to null. I
can get the name of the control using ActiveControl.Name but I can't figure
out the syntax to change the value of this control. I've tried assigning it
to variables but variables aren't working in a:
Forms![variable]![variable] = ""
"Sondreli" <Sondreli@discussions.microsoft.com> wrote in message
> I'm writing a routine to change the value of any Active Control to null.
> can g...Pivot Tables & changing data
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)
I am working with Excel 2003. I have a pivot table already set up and the
information is pulling data from a row titled "sum of Subscriber". I added
new data in a new column from the main spreadsheet and I would like to pull
the data from there. Its titled "Adj Subscriber".
Is it possible to switch it? If so, how?
Thanks, Anna Marie
> Hi - I have never used pivot tables in Excel before so hopefully what I am
&...Excel sheet truncated after copying to powerpoint slide
We are using Office 2000 with sp3. When we copy excel sheet to power point
slide, some of the rows and colums are truncated. Also the font size is
changed. We can see only some part of the sheet.
Let me know if anybody faced this problem..
Thanks in advance
Debra Dalgleish posted this link that you may want to review:
> We are using Office 2000 with sp3. When we copy excel sheet to power point
> slide, some of the rows and colums are truncated. Also the font size is
> changed. We can s...How to create a connection point in Excel
When I group autoshapes the group itself does not have connection points. A
connector connects to one of the grouped shapes instead. So, the connector
beginconnecedshape (or endconnectedshape) property contains the name of the
contained shape and not the name of the group. Is there a way to create
connection points for a group? Alternatively, is it possible to change a
group into a single shape with connection points?
...Count problems[Excel 97]
I did a search on the forum to find an answer to my question but didn'
Here is my prob :
Lets say I got this page->
1 Name Type Job bla
2 Name Type Job bla
3 Name Type Job bla
4 Name Type Job bla
5 Name Type Job bob
I want a Cell to write how many row I got( 5 in this exemple) and onl
count the cells with bla in the D column(4 in this exemple).
Sorry if I'm not really clear but if you can help me feel free t
-----------------------------------------------------------...Viewing an Excel sheet w/out all the empty fields...
How do you create a spreadsheet that only shows the fileds with data in them?
-How do you get rid of all the empty rows/columns, to ease viewing for those
who are easily confused by excel spreadsheets?
(I don't know how else to emaplin my question... I just don't want the
extra columns & rows there, if that's possible...)
>I just don't want the extra columns & rows there, if that's possible...
Just hide them!
Suppose the last column in your sheet that contains data is column H. You
can hide columns I:IV so that after column H all you ...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...How to change default printing parameters on Excel & ......
How to change the default printing parameters on Excel & keep them changed
for future workbooks.
Example: Normally I use Printing margins 0.25 on all directions, but
default printing margins are 0.75. I want to change them to set 0.25 as
If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt.
Excel will use that as the basis for new workbooks.
You can change a lot of settings that way--including orientation,
> How to change the default printing parameters ...Excel question #9
Is there a way that I can transpose the order of the values in a cell? For
example I have the values of 10.200.13.1 in a cell and I want to
transpose(not sure if that is the correct term or not) the order of the
values in the cell so that they appear as 188.8.131.52.
thanks for any help as I have literally 4 pages of these kind of values that
I have to flip.
blanktree at hotmail dot com
try the following user defined function from John
Walkenbach's book Excel 2000 formulas (great resource by
Function REVERSETEXT(text) As String
' R...How to view the code for excel built-in functions?
Is it possible? -For example the function PMT().
No, the code is compiled, so it would likely be less than useful anyway.
About the best you can do is check out the equations used in Help (see
In article <OSU3OXOBGHA.1676@TK2MSFTNGP09.phx.gbl>, "serdar" <email@example.com>
> Is it possible? -For example the function PMT().
...Excel color palette missing colors
Opening a workbook with text formatted in color (orange) defaults to gray.
Examination of the color palette shows that that shade of orange is missing
from the palette itself.
Exiting Excel and restarting it sometimes solves the problem. Text rendered
in orange is orange again and the color swatch is back in the palette. User
has tried rebooting the system too.
...How do I convert time (hh:mm) to value ($$) in Excel?
Would like to calculate cost of time. Eg. Cost for production down time per
minute is $100. Says production doen for 3.5 hrs, what is formula shall I
apply in order to generate the cost (in $$).
> Would like to calculate cost of time. Eg. Cost for production down time per
> minute is $100. Says production doen for 3.5 hrs, what is formula shall I
> apply in order to generate the cost (in $$).
"ahfen79" <firstname.lastname@example.org> wrote in ...Change color of multiple autoshapes
I need to change the color of several autoshape based on different cells
I know how to change one autoshape using a worksheet_change event
but i can't just copy and paste this and change the object name + cell name.
is it possible to have multiple worksheet_change events in the same
You have only one worksheet_change event, but in it you can test to see which cell was
changed with something like
If not Intersect(Target, Range("A1") is nothing then
' do range A1 stuff here
If not Intersect(Target, Range("A2") is nothing then
...Where can I get UNLIMITED Excel stock qoutes?
The Excel Add-in that allows you to retrieve stock qoutes is limited in taht
it only allows you to get about 250 qoutes at a time. How can I get
unlimited qoutes in a format compatible with excel?
There's a program called Historical Stock Quotes which can create tab or comma
delimited files that can be read into Excel.
If you want something that updates automatically within Excel, you may have to
buy an add-in. Have you searched the web?
On Sun, 6 Mar 2005 12:18:23 -0800, ZouBCivil
>The Excel Add-in that allows you to retriev...Excel 'hangs' when deleting a row
when i delete a row in excel 2000, everything locks up! and when
lookup at Task Manager/Processes, it's MEM USAGE goes up to 22K o
i tried doing it in another file but i experienced no error. the dat
is in LAN. all data are filtered when the deletion began. however i ca
delete files before. please help, anyone....
Message posted from http://www.ExcelForum.com
The best thing is to free up memory (assuming your file is large). Clos
all applications you do not require at the time and any workbooks no
Message posted from http://www.ExcelForum.com
...Recovery after "do not save changes" selected accidently
I mistakenly clicked on "do not save changes" for a
worksheet (file) that i'd been working on (I thought a
different file was highlighted). As it turns out I had
not saved the original file in over a day, though the
autosave is set up.
is there any way to get my file back, or at least an
intermediate version, instead of one with a day's less of
Thanks very much for your help!
Sorry to say, but your day's work is gone.
Greeting from the Gulf Coast!
"Mayukh" <email@example.com> wrote in...Excel and NPV
I have a problem regarding the NPV function on Excel. Does anyone know how
to use the function if the interest rate changes over a period of 20 years.
Say for example, for the first 8 years the interest rate is 8%, then for the
next 5 it's 12%, and for the last 7 it's 14%.
It would be great if any one can me with this!
As far as I can tell, there is no way you can vary the discount rate in the
NPV function in Excel. In fact it is very difficult to model this in any
Here is an interesting article which may help you see the difficulty;
http://...Scrpit when trying to change CRM option in Outlook client
I get the attached script error when i try to change the MSCRM Option in
MSCRM Outlook client and it does not accept my changes.
An error has occoured in the script on this page.
Error: Type Mismatch
URL:http://localhost2525/tools/personalsettings/dialogs/personalsettings.aspx?clientid= etc etc
Please let me know if any one knows how to fix this issue, thanks.
...Paths to becoming an Excel Expert
I am a retired accountant, and have used Excel for many years, including
power user, macro and VBA development.
I would like to specialise in this field + maybe delivering Excel training,
maybe offering my services as a freelance.
What is the best path to develop this expertise? Is there a worthwhile
Microsoft Certification route - which I find confusing? And finally is it
worth sticking with VBA which seems to be on the back burner now?
Thanks for any suggestions.
First, some links to several "Excel Experts"
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
I used to save files like this in "read only recommended" mode.
File|SaveAs|Tools|Ge...Changing a username/address
I work with someone who just changed her name, and I'm trying to figure out
how to change it on the Exchange (2000) server.
I changed the username in Active Directory (also 2000), but messages from
the user still have the old name in the Sender field. Also, when I point to
the mailbox for saving messages, it has the new name (Mailbox - New Name)
until restarting Outlook, and then it has the old name.
Do I have to Exmerge out the mail, delete the account, re-create the
account, change the name of the .pst file and import the mail?
Thanks in advance!
Follow these steps:
=...autoformatting issues in excel
How do I input '12-1' in excel without it autoformatting my input to '1-Dec'?
Precede entry with apostrophe '
> How do I input '12-1' in excel without it autoformatting my input to '1-Dec'?