change mm to decimal
If it's 22 min, I enter =22/60 to get 0.37. Is there a faster way that
I can enter just 22 and it converts to 0.37 for me and I still have
the option to see it in minutes if chosen?
In B1 enter this formula.
Drag/copy down as far as you wish.
Cell will be blank until a number is entered in column A
With event code..................
This code will add the decimal value to adjacent cell.
Private Sub Worksheet_Change(ByVal Target As Range)
Const myRange As String = "A1:A10&quo...In Excel, how do I change the rows into columns?
a b c
l m n
x y z
a l x
b m y
c n z
Copy the cells, move somewhere else on the sheet or to another sheet, select
Paste Special | Transpose
"Novice SS User" <Novice SS User@discussions.microsoft.com> wrote in message
> Current spreadsheet
> a b c
> l m n
> x y z
> Desired spreadsheet
> a l x
> b m y
> c n z
...disdappearing messages in Inbox
All of a sudden my inbox emails are disappearing. After I
read it, it goes away. In fact, all my inbox emails I
have had for 4 months have dissappeared. I have subfiles
and they are not dissappearing only the Inbox. I scanned
my hard drive for a virus, and it did detect. It was
deleted. It was an incoming email.
I rebooted and still I have the disappearing act. ?They
disappear 6 seconds after they arrive even if I don't
read them. whatttttzzzz happnen
Should I reinstall Outlook?
I also have another problem. When I have a plain text
email sent to 20 people it hangs up and sends t...How do you change the default working folder in Publisher 2007?
In the Options section of Publisher 2003 you could change the default working
folder from My Documents, but this option has disappeared from the 2007
WindowsXP? The Publisher developers forgot to add this to the options tools.
Create a folder for your Publisher files, add it to "My Places", when you save a
Publisher document, click the folder.
Mary Sauer MSFT MVP
"carljh" <email@example.com> wrote in message
news:EA3DE838-8282-418E-A6CC-60521CBEC085@mic...preventing date from changing
I have an If condition that sets the date to "today()" true or "today() + 1"
if false. My question is how do I prevent the date from changing? If the
date is set for today, then tomorrow I don't want to "update". How can this
You could copy the cell, and paste as values, before you close the file.
(Edit>Paste Special, Values)
Or, you could enter today's date in a cell in the row (Ctrl+; ), then
refer to that cell in the formula. For example, instead of:
=IF(A2="Local...Can I save format changes to a Pivot Chart?
Once a Pivot Chart has been created in Excel I can edit the format of the
chart (such as changing colors, lines to bars, chart type, etc.). Once I
pivot to new information, however, the formatting is lost and the chart
returns to its original format. Is there a way I can save the format so that
the chart keeps the formatting even when I pivot the data?
Some things yes, most things no:
1. To beat the color changing problem, choose Tools, Options, Color, and
change the default chart colors at the bottom. This effects every part of
2. Data labels can be retained, but n...Error message et.dll
Using Outlook 2003 with Win XP I keep getting the
following error message "the add in et.dll cannot be
installed or loaded The problem may be resolved by running
detect and repair". I have run detect and repair twice,
but the error box keeps reappearing. Once the box is
closed, Outlook seems to be functioning properly, but the
message is annoying. Any help would be most appreciated.
Delete the addin by going to Tools, Options, Other, Advanced Options, Addin Mgr.
Many thanks, no more error messages.
>Delete the addin by going to ...Changing the page setup for printing
Currently, when my report prints, it is in landscape.
How can I change it so that it prints portrait and is reduced 75%?
Is it possible to set this up in a macro?
Open your report in design mode and then setup your layout and properties and
you want them to be. In your case goto Page Setup and change the page
orientation to portrait. Then set your page content to fit within the page
boudaries. Save your changes and then this is the way they will be from now
Hope this helps,
For Access ...Receiving Duplicate Messages
I recently tried to set up Outlook Express on a 2nd
computer. Since that time I am receiving duplicate
messages from senders.
How can I stop receiving dual messages?
Have you configured this connection (presumably to a POP3 server) to
"delete" messages on the server after download? If you, should to stop
the duplicates. However, this in confict to have OE running on a second
machine where presumably you want to have duplicate mails.
That's what IMAP servers were invented for ... If you can use than
protocol instead of POP3, then do so.
Hope this i...outlook feature to prevent forgetting attachments
Often people forget to send attachments with emails. Very often they will
write something along the lines of "I have attached the minutes from our
meeting" and then forget to atcually attach a file.
Is there a way therefore that outlook can check the text of an email for
words like attach, attached, attachment and query the user before sending if
there does not appear to be an attachment?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree"...OK to change field name in table?
Can I change the name of a field without causing havoc to the table's
I have for example address-1 which is not a correct form, should be
for example address_1 - correct?
"Geoff Cox >" <<> wrote in message
> Can I change the name of a field without causing havoc to the table's
> I have for example address-1 which is not a correct form, should be
> for example address_1 - correct?
Sure, you can change it without harming the tabl...cant not change history on a shared workbook
I have an excel 2003 file, that is a shared workbook, the file is huge, and I
know if I uncheck and recheck the shared option, it will clear my history and
decrease the file size. but I would like to change the amount of history it
is keeping. (defaulting 30 days) When I go Tools \ share work\ advanced
tab. only the keep history for 30 days is grayed out, and all the other
options are availble, I can not figure out why, can anyone please help me
...Outlook won't display body of plain text message
New install of Office 2003 basic (Outlook (11.8002.6568) SP2) running on XP
Outlook is setup for one POP3 account. Any messages received that were
composed in HTML are readable. The body of all messages received that were
composed in plain text is not displayed. If I turn on autopreview it shows
the first few sentences of the plain text message but if I double click the
message the reading pane is empty. If I turn the reading pane on and
autopreview off the reading pane is empty for plain text messages. If I turn
the reading pane and autopreview off and double click the message the
...Sales due date does not change
Does anyone know why the due date in sales does not change whenever a sales
person goes in to an activity?
...Prevent the sales from Tendering when another Item is Scan at POS
We have serveral items that our Retail does have price assign to them. The
cashier will scan the next item. They will not notice the last item they did
not enter a price. Now the 2nd item is the price for the 1st item. Then the
cashier will tender out the sales without noticing they have an incorrect
total for this transaction. Then the store manager have to performed a post
void for this transaction, which hold up the customer awaiting to check out.
Have anyone else encounter this and know a way to limited sale from being
total out of an acceptable sales amount...Changing/Manipulating Legend range for a Pivot Chart in XL2010 vs XL2003 and below.
In previous versions of Excel (<=2003), upon creating a pivot table
and chart to obtain a contour map, for example, one could manipulate
the number of colors/contours (major/minor units) via double clicking
in the legend on the Pivot Chart. One was then presented with a dialog/
option window that was somewhat similiar to the functionality of
manipulating standard chart axes, i.e. one could manipulate/change
major and minor units to achieve the desired number of contours.
In Excel 2010, I am unable to find the/a way to acheive the same end.
I have the contour chart (based on the pivot table...prevent user from deleting a tab prevent running macro from menu
how can one prevent a user from
1. deleting a specific tab in a workbook?
2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?
Protect the workbook's structure.
In xl2003 menus:
tools|protection|protect workbook|check structure
Make the sub private:
Private Sub testme()
This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.
> how can one prevent a user from...how can i change the letters in the top row to words
You can use letters or numbers or nothing.
Tools|options|General tab|check/uncheck R1C1 Reference style
tools|options|view tab|check/uncheck row and column headers.
But there's nothing stopping you from putting headers in row 1 and then freezing
panes so that row 1 is always visible.
As a user of excel, I expect to see the row and column headers. So I don't see
a problem showing them. And since many people like A1 reference style and
others like R1C1, I (as a developer) let them see what they want.
If you want to try freezing row 1 so that it's always vis...how do i change currency value into words automatically
Please let me know how i can change $456 to Four Hundred and Fifty Six
dollars automatically in Excel.
(remove nothere from email address if mailing direct)
"Richie" <Richie@discussions.microsoft.com> wrote in message
> Please let me know how i can change $456 to Four Hundred and Fifty Six
> dollars automatically in Excel.
...Data Changing Issue
I am running some queries using a form I created and for some strange reason
some people are falling off and coming back to the report when I run the
queries and then re-run them immidiately after. I am not changing any of my
parameters and the data is not changing in the tables I am linked to. Can
I am using Access 2003. I have several different queries running as make
table queries from Foxpro database linked tables. Within these queries I
have one query that has a parameter set for "Married Date" What this does is
prompt the user to enter a start date an...Changing image on a toolbar
I currently have a Toolbar which is associated with a bitmap of all the
images for the buttons.
I also have a new set of icons I wish to use to replace the outdated ones I
Is there a way that I can associate my icons with the individual buttons of
my toolbar, or will I need to convert my new icons into bitmaps and redraw
my bitmap for the toolbar?
On Dec 3, 10:03 am, "Tony" <lazyherb...@homeandresting.com> wrote:
> I currently have a Toolbar which is associated with a bitmap of all the
> images for the buttons.
> I a...Lock format changes
Is there anyway to lock format changes. Specifically, users are clicking and dragging cell values down the columns. I know education is the answer....copy/paste special/values only, but this is a bunch of old dogs that dont want to learn new tricks. I would like for them to be able to click and drag down but not copy borders and shading. We are using xl2000
I saw Gavins reply in a previous post recommending to unlock the cells in question and then protect sheet. This doesnt appear to work. I might also add that copying down changes the Font size. The size currently alternates bet...Error (0x80040115) message & slow email
Task 'MSN Mailbox - firstname.lastname@example.org - Sending'
reported error (0x80040115) : 'The operation could not be
completed because you are working offline or because of
an error on the network. Try to connect to the network
again, and then repeat the operation.'
I always get this message when I send mail through
Outlook 2002 SP3 & also email is very slow.
...Re: preventing distribution lists from printing
I work for a large corporation and I often get outlook mail with ver
long distribution lists. Is there any way to prohibit these lenght
list from printing so that I only get the message?
Posted via http://www.mcse.m
View this thread: http://www.mcse.ms/message548641.htm
...HOW DO YOU CHANGE VALUE OF USER-DEFINED FIELDS outlook 2007
I can create user-defined fields, but cannot edit them by clicking on
properties. I think I have in-line editing on, but none of the fields can be
"I think" isn't really good enough for troubleshooting. You need to be sure
that in-cell editing is on. You might even want to create a new view.
Depending on the type of items, a custom form might be another way to make
it easy to edit custom field values. VBA code could also be used.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrator...