my spreadsheet keeps formatting 10-12 as 10 Dec, how do i stop it
10-12 is a size not a date, although I have formatted the cell as text, it
keeps reverting to custom
Preceede your data entry with an apostrophe [ '10-12 ], which will *not* be
displayed in the cell, but will be visible in the formula bar.
Please keep all correspondence within the Group, so all may benefit!
"pinbrook" <firstname.lastname@example.org> wrote in message
10-12 is a size not a date, although...Newbie needs help to know how to access data from a PDA to a DataBase.
Could you pls help me get an idea on the basics of getting a data to
and fro to a Database from a PDA,i am using PPC2003 Emulator and
developing on EVC++ 4.0. And pls Pls include example codes if
possible....Thanks a lot in advance. I have to populate for e.g
,customer details form in the PDA with data from the oracle server.How
exactly do i do tat and wats the code for odbc connectivity.I am really
Just have a look at the following link.
http://www.codeproject.com/ce/ado_ce_ca.asp?...Excel File Corruption
I have a large excel spreadsheet (exceeding 5MB) that suddenly failed to
update cell references. Due to the amount of changes being made on this
particular day, I had put about three hours of work in ( all saved
periodically) when I realized that cells referring to other celss were not
updating when the values of the xource cells changes. I also discovered
that cell references had failed to update when rows were added above the
I work for a large international services firm, but our in-house tech group
had no answers, excpet to suggest closing everything, re-booting, and
reope...How do I cut and paste using a macro....
I'm having trouble creating a macro that will let me cut postcodes
from one cell and paste into another cell. I would appreciate if
anybody can help me.
What I have, is a large excel spreadsheet with a couple of thousand
names and addresses. The address fields start in column B through to
G. Each line of the address should be in a separate cell within each
row, but the postcodes have all ended up in the same cell as the last
line of the address. I need to cut the postcodes out of these cells
and paste them into column H which is empty.
The addresses are different lengths, leavi...mail flow count
Are you guys aware of a tool that counts all the incoming/outgoing e-mails
for an Exchange organization?
It will probably count all the e-mails from the transition logs or from the
Message Tracking logs.
The products usually recommended are Promodag Reports and Quest
MessageStats, although if you want to do something for free, try LogParser
"SorinD" <SorinD@discussions.microsoft.com> wrote in message
news:75FF3408-E4FA-4E...Incorrect Date Format
Hello to all,
1. Excel 97 SR-2 and Windows 98SE, Short Date Format dd/MM/yyyy
I wrote a macro that imports dates (dd/mm/yyyy) and stock prices from an
Access database, then adds some formulas at the bottom of the data to
calculate highest and lowest prices and the corresponding dates.
Works fine, and the formulas correctly return the price and date (in
dd/MM/yyyy format, without needing to format the cells).
2. Excel 97 SR-2 and Windows XP Pro SP1, Short Date Format dd/MM/yyyy
The macro created in 1. above works fine under these conditions, but the
formulas that return the...Excel in Office for Mac 2008 features
I've had Excel crash numerous times the first day using it. THe Auto Save feature does not seem to be working. Each time it crashes it brings back the old saved spreadsheet with none of the changes. Auto Save is set to 10 minutes and sometimes it had been hours and still reverted back to the old saved sheet and not the updated autosaved one.
In article <email@example.comR9absDaxw>, Foosh@officeformac.com
> I've had Excel crash numerous times the first day using it. THe Auto Save
> feature does not seem to be working. Each time it crashes it brings back th...Unable to open Outlook2003. Error: MAPI unable loading msncon.dll
I am trying to set up Outlook 2003 on home computer but keep getting the
following message when trying to open application.
MAPI was unable to load the information service msncon.dll.
Since I am not open to open, I cannot get to the help feature.
Have you downloaded the latest MSN Connector from their site? Or, if not
using it, have you uninstalled it? Try opening Outlook in Safe mode
(start->run->outlook.exe /safe) and go into the Advanced options and uncheck
it from add-in manager or COM add-ins.
Milly Staples [MVP - Outlook]
Post all replies to the group to ...Conditional Formatting #33
I have a very large spreadsheet where I would like to use conditional formatting...I have the columns set up with times as follows
Arrival Time Triage Time Registration Time To ED Time DC Tim
Numerous people input the times and they are not always correct (people are DC before they arrive, etc.) There are about 3,000 lines for one months worth of data.
Is there a way I can put Conditional Formatting so that if Triage Time is Less than Arrival Time then it can highlight a cell?
This worked!!! This is going to save me hours of time each month. Thank you!!!
...Error when tracking an e-mail if recipient is in CRM or Active Dir
We are experiencing a problem when a user attempts to send an e-mail with the
Outlook client. If a recipient - To, BCC or CC - is a user in one of the CRM
picklists (Contacts, Users, etc) an error is generated indicating that the
user does not have sufficient privileges for the operation. If the recipient
is NOT in one of the CRM lists, no error is generated and the email is
attached to the account referenced in RE: .
This is happening for the salesperson role, but not for the sales manager
role, so obviously there is some privilege that I need to grant the
salesperson role, but i ca...Word Wrapping in Excel
I am having trouble with Word Wrapping in Excel. It does not adjust th
row height properly. I have tried Format, Rows, AutoFit and it stil
Mandy11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1300
View this thread: http://www.excelforum.com/showthread.php?threadid=27632
do you experience this with merged cells. If yes->nothing you can
really do about this without using vBA
> I...Horizontal line chart
I have prepared a bundle of column that has one XY scatter plot serie
It works great, updates with VBA, no problem.
Now I was asked to add one additional point in each serie to the char
with some calculations. Although looked to be be very easy job, it'
not, as the file get corrupted while modyfing the data source for thi
chart using the MS chart interface. I've tried to put the modificatio
into the command line and it works for the chart. Unfortunately it doe
not record while macro recoding ('Macro recording not possible' error
that is essential to update automatically t...Unable to Edit/Add records on Form in a New ADP
I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.
SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate
Recordset Type: Updatable Snapshot
I'm getting the 'This recordset is not updatable'
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
"D...Office 2007 Excel
Every time i open Excel 2007 i get the following; "The file you are trying to
open,'PDFMaker.OLDxla',is in a different format than specified by the file
extension. Verify that the file is not corrupted and is from a trusted source
before opening the file. Do you want to open the file now?" I pressed
CTRL+Shift+I and receive the folowing id 101786 however I could not find
anything relating to the above. As a note you have to press NO two times
before you can get into excel.
Hope I got this in the correct discution group.
If you're not using the pdfmaker.* addin, how...Unable to open calendar
Folks, i cannot open or view my calendar.
When I start Oultook a Pop Up appears saying "Could not read the Calendar"
On clicking Ok, the pop up vanishes and nothing happens.
If i then go over to my calendar, it says "Cannot display the folder"
I have run Oultook Diagnostics and nothing shows up as irregular. I ran the
repair function (off my setuo CD) and nothing happened. I also re-installed
Outlook and rebooted my comp and nada.
When staring in safe mode i also get he same errors.
I am using Off 2007, Win 7
"phamiltonsmith" <...Excel 2003 sum if or count if ... or is it something else ???
I am using Excel 2003 and am really stuck on getting a sum or count function
to work if it matches another column. I know this might be bread and butter
to some of you but as a bit of a novice, I've tried what I consider to be the
obvious and get nothing.
My problem -
On a sheet B I want to sum (or count) all the times "Telephone" occurs in
columns F or G only if "Other" occurs in columns K or L, these columns being
on sheet A.
See, told you it was simple enough ... but please Please PLEASE how do I do
My sheet A uses 14415 rows, and columns ...Prevent information copied in one Excel window to be pasted in another windows
Hello. Since Excel is not multicore aware, I am forced to have two
different windows running Excel, ie, i start Excel in one window and
start another session of Excel in another window, not in the same
window by doing file\new). But since I am running macros in each, and
because my macro copy and paste information, sometime the windows
interfere ith each other which prevent one of the macro from running.
Is there a way to make Excel not able to paste in another window?
Thanks for the tip.
...Multiplying in Excel
Why does excel and my calculator come up with different answer when
multiplying numbers with decimal points? Excel seems to be off by a couple
hundreths of a point.
On Thu, 3 Feb 2005 07:53:03 -0800, "albebach"
>Why does excel and my calculator come up with different answer when
>multiplying numbers with decimal points? Excel seems to be off by a couple
>hundreths of a point.
Hard to tell why you get the results you do when you post so little
The most likely answers have to do either with you not realiz...Need to read PAR PORT data bits URGENT
I have never read a parallel port in MFC yet. I need to read the input data
on the port tonight for a dog and pony tomorrow. I tried the CParallelPort
class but it didn't build and seems more than I really needed.. I am just
reading the state of the bits as there is a rotary switch connected to
ANy links or methods.. AM I missing the obvious?
Thanks again all.
First, using the parallel port for anything is intrinsically dangerous. The standard
parallel port driver does not support reading from it. (Besides, modern machines don't
have parallel ports). You wil...Excel
1. Look at a worksheet ; the range A1:A10 is filled with text data.
2. Enter into cell C1, = Countif(A1:A10,"<="&A1:A10) ; it works.
3. Then, the range B1:B10 is filled with text data.
4. Enter into cell C2, = Countif(A1:A10&B1:B10,"<="&A1:A10&B1:B10) ;
it does not work.
5. Please offer an explanation that it does work and then it does not
I'm having a bit of a hard time understanding what you're trying to do...
is functionally equivalent to
=COUNTIF(A1:A10,"...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect...Mail Box Size #2
I have a user with a 6 gig + mailbox. We are using Exchange 2003
(enterprise) and Outlook 2003. He is now experiancing problems with the
program running like a slug. It doesn't appear to be locking up, just
taking for ever to do everything. He claims it was fine until front page
crashed, which took the computer down (needing a re-boot) and outlook hasnt'
worked right since.
So what I have done, is delete the profile and recreate, appear to work for
me, but now is locked up again. The auto archive does not appear to
removing items from the mailbox.
Does anyone hav...in excel formula the comma (,) is no longer accepted but the semi.
when entering formula in Excel the comma (,) is no longer accepted but the
semicolon (;) now has to be used.
Previous : =if(a2="Yes",a3+a4,b3+b4)
Now : =if(a2="Yes";a3+a4;b3+b4)
How do I change it back to using commas. I don't know how this has happened,
I just arrived at work one day and the changes has occured.
Not a 100% sure how well XL honors them, but check your Windows
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <5...Can I set the numerical type of Cell to Hex format
Sorry to post again. Can I set the numerical type of the cell in Hex
format, because I want to do the following task. Thanks.
Now, if I type in 01/0001 in cell, and then I drag the mouse down to
many cells , the number in the cell will be added by 1 automatically, just
like the following
Now, if I type in 01/0001 and I want to drag the mouse down to many cells
and I want the cell to add 1 automatically in Hex format. Can I do that?
Simply, I want the cell t...unable to scroll the page
on microsoft office frontpage 2003 - when i up loaded my web pages to my web
site www.millertimeauction.com , there is no sroll bar for up & down of page -
it scrolls for me in IE8
scroll bar will only appear if it needs to
Microsoft MVP Expression Web
"FrontPage Error" <FrontPageError@discussions.microsoft.com> wrote in
> on microsoft office frontpage 2003 - when i up loaded my web pages to my