6:49:00 AM converted to 00:06:49 AM
I have a column of time that is showing the minutes as hours and th
seconds as minutes. Example=> 6:49:00 AM needs to be converted t
00:06:49 AM. I need to shift everything to the right one semicolon.
am formated as [hh]:mm:ss. This column does not have a set amount o
rows therefore the fix needs to effect the entire column and should no
be cell specific....By the way this site is a huge Help....I want t
give a big thanks ahead of time
Message posted from http://www.ExcelForum.com
Create a backup in case you want the original data.
Put 60 in an empty cell
Se...Linking Excel to Visio
Is it possible to limk the text box associated with a shape to a cell in ann
this was offered by another user (rene)
There were two kb articles describing the steps to set up a link between
Visio and Excel
"Mark Dullingham" <MarkDullingham@discussions.microsoft.com> wrote in
> Is it possible to limk the text box associated with a shape to a cell in
...Show alternate or different characters
I have a column that contains Social Security numbers. I would like this
column to display the numbers as 'xxx-xx-1234'. I can't seem to be able to
figure out how to do this. Cell formatting doesn't tell really say about a
Select the column
Click Format > Cells > Special > Social Security Number
GMT+8, 1� 22' N 103� 45' E
"Greg Hill" <Greg Hill@discussions.microsoft.com> wrote in message
news:D654E9DC-9EB2-41D0-BAC5-F8EA7F3303B...Invoice Designer Money 2003
I am using Money 2003 Deluxe & Business with all the
updates. I am having a problem with the invoice I designed
in invoice designer not able to transfer from computer to
computer. I sometimes take my money file home to do work
and when I go to print a invoice at home the Invoice I
designed at my work office does not show up. What am I
doing wrong. Please help!!!!
I have the same problem, Invoice Designer doesn't work on different
"Chris" <email@example.com> escribi� en el mensaje
...2003 Attachment problem
This happens on two different systems I use, one Exchange based the
other POP based.
If I right click a file, then Send To - Mail Recipient, the message
windows freezes. The email is sent, but I have to kill the message
window. No problems if I attach to an email, and the Beta didn't do
...Unread Meail box constantly shows there are unread messages
My "Unread mail box" indicates there are 2 unread mails - but no mails
are listed in the folder. When I receive further mails, the ounct goes
up and the new mails ar shown in the folder, but, always, the count of
unread mails is two more than are shown.
Is there a way of curing this?
Do you perhaps have a filter applied to that view?
If you are not bothered about where the count is coming from simply right
click the folder and choose Mark All as Read.
For the next time; don't multipost but crosspost instead; it will leave the
discussion i...Outlook 2003 #80
Does anyone knoe how to get Outlook 2003 to download an EXE file?
Indeed - Is it ever possible?
Thanks in advance
Are you reading the replies to your posts?
"Crispy" <firstname.lastname@example.org> wrote in message
> Does anyone knoe how to get Outlook 2003 to download an EXE file?
> Indeed - Is it ever possible?
> Thanks in advance
There is a registry edit that will allow you to over-ride
the built in security. Look it up in the knowledge base.
Otherwise, ...Can't refer to Detail Report control on Page Footer?
I have a control in the detail section ([TotalHrs]) of my report that
adds the Nz([DayValues],0) together for 16 other controls. This
control works fine.
The report is grouped on EmpID, with a force new page on new value
(using the ForceNewPage After Section in the EmpID Footer).
Now, in the page footer, I have a control ([SumTotalHrs]) that I want
to total the section's worth of hours (By using the running sum
feature Over Section). Granted, this will not look correct if EmpID's
section is more than two pages, but it doesn't even work. Apparently
I'm doing something wrong. I...donot show hidden files in CFileDialog
If you have the hidden files visible in Explorer -> Tools ->Folder
Options -> View tab then all hidden files are visible in CFileDialog as
Is there any way to override this behavior. I want all hidden files
hidden irrespective of what the system settings is , in one of my
As far as I know, the CFileDialog displays files/folders according to the
user settings. There is no way to change this behavior.
-Atul, Sky Software http://www.ssware.com
Shell MegaPack For ActiveX & .Net - Windows Explorer Like Shell UI Controls
<rajkumar@hot...Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?
I want to use Picasso Photo Viewer (PPV) to open images that are HTML linked
within a MS Officer 2007 - Excel spreadsheet. I've looked at file
associations (using MS 7 OS) - but to no avail. Currently, IE opens up, then
prompts me for an Active X overide and opens it with Quicktime.
Any solutions please? In XP with MS Office 2003, it was just a matter of
chaning the image to a proprietory PNG file. PPV is engaged if I just open
the image within the folder - but not from the spreadsheet HTML link?
...All rules stopped working
This is a multi-part message in MIME format.
all my rules stopped working today in my outlook. 2 days ago I created =
new profile and set it up to deliver to local PST (quota issue on our =
exchange). I re-worked my rules and they were working just like before. =
Today they stopped working. I tried export - delete- import. I tried to =
delete rules and re-create them but nothing helps. If I run rules =
manualy they are working. Any ideas?...exchange 2003 sp2 database
Someone told met that I should not let the mailbox store grow above 32 GB,
because it will start corrupting.
Can someone tell me if this is true? I cannot find any information about
what happens when the store grows bigger that 32 GB.
We need the functionality that SP2 gives regarding the 16 GB limit.
Thanks in advance
That is total nonsense. Exchange can manage very large databases.
The limiting factor in database size is backup/restore windows and
"Ruud Boersma" <RuudBoersma@discussions.microsoft.com> wrote in message
news:127CBDC8-65E3...Outlook 2003 MRU
Does anyone know how I can get access to the Outlook 2003 MRU list that
contains email addresses that I have used?
My Sent items has been cleared down but I have a whole load of mail
addresses to add to my contacts list and they are all in the MRU list that
pops up as I start to enter an email address to the "TO" box ...
Jon Rowlan <email@example.com> wrote:
> Does anyone know how I can get access to the Outlook 2003 MRU list
> that contains email addresses that I have used?
> My Sent items has ...forwarding internet e-mail in office xp
Since I upgraded to office XP, if I get an e-mail from an
internet source and want to forward it our "all" account
which includes everyone in the office, it get returned.
This does not happen on the Office 2002 machines, only on
the Office XP machines. No other problems with e-mail
Office XP includes Outlook 2002 - what are the actual versions of Outlook?
Look in help | about.
What is the exact text of the NDR (non delivery report)?
Is your Exchange server handling *all* your mail or are you using Internet
mail in Outlook?
> Since I upgraded to off...Creating GIFs in Excel 2003 for use in Dreamweaver
I have used Excel in the past to create GIF files of charts to be uploaded to
the Web through Dreamweaver without difficulty. Using Excel 2003, however,
GIF files that I create by "saving as web page" turn out fuzzy when posted to
the web. (They look fine when copied to Word or Paint -- haven't tried
Photoshop.) This is true whether I use a chart from an old file created in
an earlier version of Excel or a new chart built from scratch in the Excel
2003. I've looked through the chart settings to see if my new version of
Excel is configured differently from the old, ...Different Header on First page in Excel
Is there a way to not have the Header show up on the 1st page of an Excel Spreadsheet?
Would like the answer to this from Excel 2000 and 2003 formats.
Try this from Ron de Bruin posted earlier this spring:
Suppress Header on 1st Page
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT
.RightHeader = "Your Header info"
ActiveSheet.PrintOut From:=1, To:=1
.RightHeader = "Your Header info"
ActiveSheet.PrintOut From:=2, To:=TotPages
En...Microsoft CRM and Exchange 2003 SP1
Does anyone know if Microsoft CRM has any known issues with Microsoft
Exchange Server 2003 SP1?
...How can I remove blank spaces from fields
I have a column of fields with some duplications. I want to remove those
duplications but all of the duplicates have a space at the end of them so are
not recognised as being true duplicates.
My question is, how do I remove the spaces from my data?
e.g. so that the two fields below both read nozzaworld
I assume your information is in column A, then in another column enter
Overwrite column A with new column copying as value
> I have a column o...Bug in Outlook 2003's contact book
Using the Outlook address book (SP1)
When setting up a new contact I add their telephone number. Next thing that
happens is that I get a Location Information window appearing asking for my
location in order to setup auto-dialing...
If I hit cancel and then to the question "Are you sure you want to cancel"
select Yes the Location window doesn't close, worse still it's stays in
focus and doesn't allow me to continue working with Outlook.
The only solution is to enter the details which then takes me on to the
Phone & Modem options.
I don't have a modem, and t...Visio Stencils.
Using Visio Professional 2003.
I have visio stencil which denotes a patch panel.
I want to be able to change the ports, which are currently white to another
As it stands nothing I've tried has changed the colour, however if I ungroup
the stencil twice I'm able to select the individual ports and change the
fill colour. the trouble of doing this is that firstly the object is
ungrouped and second it no longers snaps to other objects such as racks.
Any ideas how can restore the orginal stencil after its been ungrouped ?
Thanks in advance.
You've run into one ...Excel 2003
There is probably no way to beat this, but it's worth a try.
I am downloading a list and if count this list with the following formula it
gives me what I would expect.
Column A = 285 names (contiguious) (Starts in row 2)
gives me 285
Because this list includes a lot of repeats and I am interested in a count
of unique names, I sort the list.
Then in column B(B2) I insert the formula =IF(A1=A2,"",A2) and copy it down.
This gives me a list with lots of holes where the repeat name occur.
I use the formula: = COUNTA(B:B) and expected a number much les...Microsoft SBS 2003 with CRM error
I have an SBS 2003, R2 SP1 server running CRM that causes two errors
every minute (exactly every 60 seconds). They coinside 60 seconds from
the time I restart the CRM Exchange Router service. The first error is a
Dcom error in the System log and the second is a MSCRMExRouterService
error in the application log. As they happen every minute, both logs are
a sea of red and fill very quickly. (CRM and the server actually run
fine and no actual issue has occured at the server or client end, just
the event logs)
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date:...writting text on visio
I want to add text to the body of my Visio 2003 network diagram I don't know
how to do that.
...outllook 2003 icon problem
I upgraded from outlook 2000 to outlook 2003. My Desktop Icon is the old
2000 icon however all other icons are the new 2003 icon. How can I change
my desktop to be the new icon?
On Fri, 28 Jan 2005 22:05:36 -0800, "Andre Monostori"
>I upgraded from outlook 2000 to outlook 2003. My Desktop Icon is the old
>2000 icon however all other icons are the new 2003 icon. How can I change
>my desktop to be the new icon?
Have you tried deleting it and creating a new one?
Email Client: Microsoft Offi...Hyperlink one Visio diagram to another Visio diagram (in Visio 200
I would like to hyperlink to many other Visio diagram within one diagram to
show a high level overview of processes. If someone wanted a more detailed
view of a particular process they could click on the Visio Diagram. I know
how to hyperlink to other file.
My questions is there a way to get a thumb nail graphic of a Visio diagram
so I can use it as a inserted graphic of the different Visio digrams?
On Sun, 8 Feb 2009 18:16:01 -0800, JPK <JPK@discussions.microsoft.com>
>I would like to hyperlink to many other Visio diagram within one diagram to
>show a high level...