use macro to change dates
I have never used macros before but am trying to convert dates using excel
2003. The dates are in the format of
+1.123.456.1234 and I would like to change that to
123-456-1234. There are also some listed as 123.456.1234 and would like
them to be the same as the first ones, that is, 123-456-1234.
I tried using the "start recording" method and "stop recording" but the
cursor just jumps back to the original cell when I try to use the recorded
macro. I have 2000 cells to change. Anybody have a suggestion on how to
change these? I looked at the VBE, but don't kno...Conditional Comment using Cell value as part of it
What I'm trying to do is the following:
if cell(a1) is different from 0(zero) then, cell(b1) should have a comment
that say, the value of cell(c1) is the payment, next line the value of
cell(a1) was refund, next line Total for today = cell(c1)-cell(a1)
a1 = $10.00
c1 = $30.00
$30.00 is the payment (c1)
$10.00 was refund (a1)
Total for today: $20.00 (c1-a1)
can anyone help me on that?
thanks in advance
...What Is The Difference Between i++ and ++i?
I use MFC. I would like to know the difference of ++ if it is used preceeding
the variable name and if it is used after the variable name?
int i = 5;
int j = 10;
"Landon" <Landon@discussions.microsoft.com> wrote in message
news:E5F8D747-65A4-> I use MFC. I would like to know the difference of ++ if it
is used preceeding
> the variable name and if it is used after the variable name?
> int i = 5;
> int j = 10;
In your example they both just get one added to them. The difference is in when
it is being used. For exampl...Why is .NET 2.0 required to deploy an app using VC2005 C++ Setup project?
I just created a setup project for my mfc app. I noticed that in the
prerequisites section the .NET 2.0 is checked by default. My app does not
need the framework (at least this is what I think). If I clear the
checkbox, build the project, and then try to deploy it on a machine with
..NET 1.1 the installer fails with a message complaining about missing .NET
I'm not sure if this the installer that needs the framework or my app. Are
there any mfc8 dlls dependant on the framework?
> I just created a setup project for my mfc app. I noticed that in the
> p...Pivot table chart problem, How to show different subtotal levels
Using Excel 2003,
I have a pivot table using external data via ODBC.
I have a chart based on my pivot table.
The table and chart are working correctly.
The PTcontains two levels of sales subtotals
1st level is by county
2nd level is by state.
My client is telling me that the data in the chart is too detailed.
He wants to have the both levels of subtotals in the PT,
but only the county subtotals in the chart.
If I delete the county sales subtotals from the chart, they are also deleted
from the PT.
Is it possible for the chart to be based on the PT and not show ...Insert fields dynamically into database from a staging table
In our lab when ever a test is performed results are stored in test_results
table ( 10 records at maximum) and with click of a button these results
should be loaded to database, but I have any issue here, each time the
test_result table will have different field names ( one time it will have
test1 , test2 , test3 with labid, next time it might have test1, test4, test5
and labid) so how can I load these fields from test_results table into
database auomatically. Datebase has all these fields so how can I map the
test_results tables fields to database fields to run my dynamic inse...Format cell to display numbers instaed of ###'s
Not sure how to querry this in the KB.... but I want to be able to have a
number such as 4 1/8 in a cell that is set at width less than what is
required to display it properly. Same with a date/time entry. In cells
where I'm entering text, the text will "spill" over if the adjoining cells
are empty of data. No so with number's.
How do I change it so it will display as 4 1/8 without widening the cell?
I place an apostrophe ' in front of the number, or format the cell as plain
text it will work, but I really need to retain the numeric value.
...Outlook Express Password #5
Last week I placed a password on my outlook express, so that no one could access it. I forget it on Monday morning, as the news of my mother's death on sunday. Please help?
There is a product called snadboy which you can install.
Once installed, you take the snadboy cursor over the
********* and it will reveal the paessword. BTW, it is
freeware I believe.
>Last week I placed a password on my outlook express, so
that no one could access it. I forget it on Monday
morning, as the news of my mother's death on sunday.
...Cell Formating Problems
This is what I do:
I open up a brand new worksheet.
I format cell A1 to text.
Then I enter the number 1 into it.
Then I format the cell to Numeric
and the 1 in the cell does not change. it stays as (left justified
If I delete the 1 and type a 1 into that cell and hit Enter, it become
1.00 (a number).
Whats happening here??? Why doesn't it convert the 1 to a 1.00 when
format the cell to numeric? Why do I have to re-enter the number
Message posted from http://www.ExcelForum.com
It was originally entered as Text. Simply re-formatting doesn't change its
underlying ...format end notes to appear at the chapter, not end of document?
I need my end notes to appear at the end of each chapter. Word puts them at
the end of the document. Can I do this manualy, or is there a shortcut
format I can use?
Right-click an endnote and choose Note Options from the context menu. At
"Location," choose "End of document." Make sure that "Apply changes to"
reads "Whole document"; then click Apply.
Microsoft Word MVP
"Liz" <Liz@discussions.microsoft.com> wrote in message
>I need my e...empty messages in Outlook Express
Anyone got any ideas on this.
Today all my email messages appeared to be blank, although
attachement, headers and file size remain.
To complicate things further, I can no longer recv or send
email, I get the following message. Any ideas?
Your server has unexpectedly terminated the connection.
Possible causes for this include server problems, network
problems, or a long period of inactivity. Account: 'Annon
BT account', Server: 'mail.btopenworld.com', Protocol:
POP3, Server Response: '+OK 1487 octets', Port: 110, Secure
(SSL): No, Error Number: 0x800CCC0F
And...How to use Find (Ctrl-F) to find non-alpha
Is there some way to search a sheet for anything BUT a-z or A-Z?
Finding numerals or a mixture of numbers and letters (and other characters)
works ok for me.
What are you having trouble with?
On 10/22/2010 16:31, Heather Mills wrote:
> Is there some way to search a sheet for anything BUT a-z or A-Z?
> tx ;-)
On Fri, 22 Oct 2010 17:54:28 -0500, Dave Peterson
>Finding numerals or a mixture of numbers and letters (and other characters)
>works ok for me.
>What are you having trouble with?
I am attempting to compile a project in Visual Studio 2005 which compiles
and links properly in VC++ 6.0. It seems to have problems with C++ i/o
functions. Here is the error I get:
g:\src\analyzer\digitdialpages.h(136) : error C2146: syntax error : missing
';' before identifier 'm_InFile'
Line 136: ifstream m_InFile;
The statment: include <fstream> is at the top of the source file.
Some assistance would be helpful. We didn't have any problems with using
ifstream or ofstream in VC++ 6.0. Thanks.
On Tue, 12 Dec 2006 18:22:47 -0500, "Raj Kulkarni...How do I create custom border using peoples names?
There are many it could be done. I'd set up text boxes and go from there.
MVP Microsoft [Publisher]
"Val" <Val@discussions.microsoft.com> wrote in message
In addition to JoAnn's reply, you could use WordArt as well. WordArt allows
you the opportunity to rotate, flip, arrange etc. and resize as well as save
as an image.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
&...Outlook Express #294
I created folders for emails I wanted to save. Decided to dispense with
several folders & compact emails into just a few folders. I inadvertently
deleted certain folders that I wanted to keep. I also deleted them from the
recycle bin. Can I retrieve these folders from anywhere behind the scenes.
I've done a restore that doesn't work for this particular problem. This is
the Microsoft Office Student & Teacher Edition 2003. TKS
proad <email@example.com> wrote:
> I created folders for emails I wanted to save. Decided to dispense
> with sever...Formatted Text in Autocorrect, Word 2008 for Mac
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
I want to set up an autocorrect entry where I replace something with =formatted= as opposed to =plain= text.
Specifically, I want to replace "qqq" with "QQQQQ" formatted in 14 pt Britannic Bold. However, I cnanot change the signal button from "plain' to "formatted" text. is there a way to do this?
Type the word you want to use to replace "qqq" and format it inside your
document. Select it, then click on Tools>AutoCorrect. You can now click the
"formatted text&...manipulating number formats
If I type in $1,238,000 I want the cell to display $1,000.
Similarly if I type in $15,965,945 I want the cell to
display $16,000. Can I do this without using the round
I do not believe you can if you are using ws functions.
Greeting from the Gulf Coast!
"Billy" <firstname.lastname@example.org> wrote in message
> If I type in $1,238,000 I want the cell to display $1,000.
> Similarly if I type in $15,965,945 I want the cell to
> display $16,00...Issue writing IF OR Error Formula Types
Having trouble putting a formala together.
I have the following formula which works:
Senario : $d$d = either weight or unit or unknown (of an ingredient)
e8= is a quantity number ( either in grams or units, o
an ingredient. eg 100 or 1)
Raw data is in nutrition!$b$6:$g$70
The following formula works so far:
f8 ( which is the no. o
But I also want to add to it that
If e8(quantity)=0 or blank or invalid then "qty?" should appear in th
And not sure what to do to avoid an error in f8...how to remove non commercial use in the title bar in office
how to remove non commercial use in the title bar in office 2007
Buy an edition that is not for non-commercial use only. You own the Home and
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Mario" <Mario@discussions.microsoft.com> wrote in message
> how to remove non commercial use in the title bar in office 2007
...Expression must evaluate to a node-set
I am using xpath within a BizTalk 2006 orchestration.
I get the following error "Expression must evaluate to a node-set".
<PersonContact EMailContactValue="email@example.com" />
<PersonContact EMailContactValue="firstname.lastname@example.org" />
My xpath expression which generates the error message:
varNoOfEmailAddresses = (System.Int32)xpath(msgEmailListRes, "count(/
*[[local-name...vlookup cant be used
I need a way to transfer data. I have one sheet that contains all
information. All of this data needs to be transferred to a template ready
for print. I have contemplated using a vlookup to quicken the method,
although the data sheet will be moving too and from computers, and so the
vlookup will not work.
Is there any code that might possibly help me, i.e. a code that looks for
the datasheet and does some sort of vlookup after it has located the file?
Or should this problem be tackled using macros, although i imagine that this
will have the same effect.
How "ready for print"? Are...Auto Fill Fields
I have a database of contacts (names, addresses, phone numbers, emails). I
have created a table with this info already filled out (imported from Excel).
All I want to do is create a form with a single drop-down list where, when
the last name is selected, all the other fields automatically populate with
that person's correct information.
I have tried DLookup but that seems too cumbersome and doesn't work unless I
go to design view and back to form view. Is there not a simple function in
Access that lets me do what I need to without having to write code. I am NOT
a code writer,...Upgrading Multiple Companies at Different Times
I have multiple companies currently in my GP 8.2 installation on a single
server. Of course these companies each share the DYNAMICS database.
I am plotting out the upgrade process to 9.0 and would like to upgrade one
company at a time, as one of them is ready to go, while the other will
require more work due to customizations.
Would there be any issue with upgrading CompanyA to 9.0 on a new server, and
then a month or two down the line, upgrading CompanyB to that same server?
Would CompanyB be able to slide right in to using a DYNAMICS database that it
had not used for a couple of...problem with adding column, formatting
I saved a workbook in quatro pro 8 to excel format and then opened it in
excel (ms office 2000). some of the columns will not permit reformatting -
changing the date format or changing from currency to accountant number
format. I can not add blank columns between columns containing data. A
window pops up indicating that Excel will not insert a column as I will lose
data. I have attempted to follow instructions in the documentation and in
the help screen but can not insert blank columns. In the transfer process
does excel end up with locked column and row structure and/or formatting of
so...format date in excel
Can you format a date in a formula to recognise the date only? i have a
column with the day number only and need to calculate the figure directly to
the right as this day number reaches todays date.
day cost to date
if todays date was 11th september, to date would be empty but if todays date
was 12th september, to date would have the figure £60.00 in it.
thanks in advance,
in the To Date column - assume it is C2
> Can you ...