anther date question
StrDate is assigned todays date with the Now function, the value looks like
3/25/2010 10:36:48 PM
....I need the value to look like this:
(the month and day have to be 2 digits)
How do I do this?
"Southern at Heart" <SouthernatHeart@discussions.microsoft.com> wrote in
> StrDate is assigned todays date with the Now function, the value looks
> 3/25/2010 10:36:48 PM
> ...I need the value to look like this:
> (the...Formatting a variable
I have the following code:
APN As Single
Dim ThisProd As ProdMatrix
tmpThisProd.APN = .Cells(tmpSrcRow, 2)
The variable is supposed to contain the number 9317382120228, but instead
Then, when I execute the following code:
Cells(LastRowDest, 1) = .APN & .StoreNo
I get the result of 9.317382E+123201 in the cell where:
ThisProd.APN = 9.317382E+12
ThisProd.StoreNo = 3201
I was expecting to get the number 93173821202283201. Why is the value of APN
taken literally and not by...Printing or formatting issue?
Please bear with me on this one, I have posted something similar in the past
and thought this issue had been resolved but hasn't!!
In Finance we have staff who work on individual worksheets, these are then
sent to one person who collates them into one workbook; this is then sent to
our Finance MD and PA. The person who sends the workbook can print all
sheets out fine on his HP5000n (A4 and A3), however the Finance PA (HP4050)
and the MD (HPxxx) cannot, they complain that the formatting is all "off".
I can confirm that all these users and those who originally created t...conditional formating 04-28-10
I have the following formula for column D and E
I need to add a formula that if a date is in column c then column D and E
What are you formatting? The font color or the cell fill color?
Microsoft Excel MVP
"Cheryl" <Cheryl@discussions.microsoft.com> wrote in message
>I have the following formula for column D and E
> =D2<Today() red
> =(D2-Today())<30 green
> I need to add a formula that if a date is in column c th...opening a new document w/ a custom stencil open
I have created a custom stencil for users in my workgroup and saved the
file to a network directory. Currently, to use it we do
FILE>SHAPES>OPEN STENCIL and navigate to the file. I'd like to make
this more transparent.
What I'd like to do is have something where the user does FILE>NEW and
when I get the "Choose New Drawing Type" I'd like to insert my custom
'templates' (not sure if that's the right term in Visio) and when the
user selects one of those it opens the editing window w/ my custom
stencils already loaded. IOW, I want it to work just like o...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...When I am in one cell highlight another
When I am in one cell highlight another. Lets say that if my cursor is in
A1 I want D1 highlighted or with another cursor on it.
Then if I move to A2, D2 should be the one with another cursor or highlighted.
Thank you for your help,
Jose Juan Diaz
hi, Jose Juan !
> When I am in one cell highlight another
> ... if my cursor is in A1... D1 highlighted or with another cursor on it.
> ... if I move to A2, D2 should be the one with another cursor or highlighted.
'put' a cursor on non-active-cell... [I don't think it's possible] :(
to highlight 'D' wh...Copying Border Formatting
I have a large spreadsheet which is essentially a diary.
I want to format the days and weeks, with thin and thick borders to
distinguish between them. The spreadsheet already has lots of varied fill
formatting for meetings that are held.
I can't see a way of either format painting, or paste special-ing, just
Is it possible?
Stanley: It's not gonna end like this.
Gabriel: Oh, come on, Stan. Not everything ends the way you think it should.
Besides, audiences love happy endings.
True enough that...Changing a customers Account Number?
Is it safe to edit a customers account number?
I have some irregularities i would like to sort out, and would rather
maintain the customers purchase history than make a new account? If i
directly change the account number - will i mess anything up?
In my personal opinion if the account number was system generated, I'd leave
it alone; if you created your own account numbers for your customers, I don't
think you'll have any issues, sql being a relational db and
all.....nevertheless, back up your db and recreate it on say your
laptop....then change one customer account numb...Format>Row>Autofit
in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far.
Text was imported from Word, other Excels etc. Up to 10 lines of text in some
cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells.
Problem is, Format>Row>Autofit is unreliable. For 90% of cells works fine
but some either show white space between text lines, or shrink too much,
cutting off last text line(s). If adjusted manually, seems unstable - will
revert for no reason.
Looks like you need to remove the formatting before you pasted into the new
when youu paste - if you ...Save document in 9 slide format view
How do I save the document in the 9 slide format view vs. the individual panes?
I would suggest printing the document to pdf.
select handouts and set to 9 slides per page.
hope that helps
"D @ rrcsb" <D @ firstname.lastname@example.org> wrote in message
> How do I save the document in the 9 slide format view vs. the individual
...custom button id
Help me please.
I've created custom button with title 'Reject' in ISV.Config for toolbar
case entity detail form. I need diasable and enable this button in
'ISV_New_780_Reject'. But then this id has changed.
And now it is 'ISV_New_596_Reject'. How do I have to determinate custom
buttons id properly?
Thank you very much!
>From my previous experience, the button id should not change unless
they change the way of how button is created in CRM recently. Are you
trying to move from...Sum If
I want to sum a # field if the 2 conditions are met. 1 - the month =
February and 2, the $'s are sales
Data is like this
D F G
Month Measure(Sales) Data I want to add
> I want to sum a # field if the 2 conditions are met. 1 - the month =
> February and 2, the $'s are sales
> Data is like this
> D F G
> Month Measure(Sales) Data I want to add
In ...conditional format rage based on entries within range
I have a spreadsheet in excel 2003 where a range of cells contain different
If there is no text in any of the cells within the range I would like the
range conditionally formated (red), however if any or all of the cells within
the range contain text then no format should be applied;e.g.
If A1 to D1 are blank format cells red, when text is entered into B1 remove
All help greatly recieved.
Select A1 to d1 and then
format|Conditional formatting - Select 'formula is'
enter the formula =A1=""
Pick a colour
Mike...Highlight Row when selected
hi is it possible to highlight a row when you select a cell on a row.
For example I select B28, the row B becomes highlighted, then when
click on B29 that one becomes highlighted and B28 become
The only cells on each row i wont highlighting is B:I.
cassy01's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=78
View this thread: http://www.excelforum.com/showthread.php?threadid=42201
Good morning (again) Cassy01
Chip Pearson provides an add in that will...highlighting rows according to a input value?
eg. value 1 and 2 in a cell should make an entire row red
eg. value 3 to 6 in a cell should make an entire row blue
Ideally I want a formula when if I put 1 or 2 into a cell it highlights
the row as red
maybe I if I input a 3, 4, 5, 6 it highlights red
Any thoughts? Thanks in Advance.
This can be done with conditional formatting.
<FORMAT> - <CONDITIONAL FORMATTING>
specify your criterium and set your format.
> eg. value 1 and 2 in a cell should make an entire row red
> eg. value 3 to 6 in a cell should make an ent...Custom Line Width in Line or Scatter Chart
Is there any way to create lines of a custom width in a line or scatter
chart? I occasionally have a need for a very thick line, thicher than the
maximum that the dialog allows?
You can fake it. I have published a few macros that draw lines and other
shapes which trace lines on a chart:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Marvin" <Marvin@discussions.microsoft.com> wrote in message
Before I get into the meat and potatoes of this macro, column "H"
will have a red (5) background put there by conditional formatting.
So really not sure if this approach will work, but here goes.
Check range Sheet1 (H5:H1968) for cell background = Red (5)
if TRUE do nothing.
If cell background = White (46) (or default I think), then DELETE
each cell contents in Sheet1 column (I5:I1968) that condition applies
Any help would be appreciated.
Default is No Color which is -4142
Gord Dibben XL2002
On Thu, 13 Nov 2003 15:18:06 -0800, RayD <rc...date format frustration!
I'm having no luck! When I enter 07/29/2004 it comes out 36735. I've tried
the format option but no luck...what am I missing?
Thanks in advance!
formating this cell as 'Date' should do
"ogawak" <email@example.com> schrieb im Newsbeitrag
> I'm having no luck! When I enter 07/29/2004 it comes out 36735.
> the format option but no luck...what am I missing?
> Thanks in advance!
Check your Date settings at T...Update Date & Time
I am new to Micrsoft Money and need help. The date and time on my computer
and in Micrsoft Monay are both correct, however the date and time it gives me
when I update new information from my bank is two days ahead of the current
date. It keeps throwing me off.
For instance, when I downloaded new information today May 20, 2005 at 7 pm
on the home page it tells me it was last updated May 23 at 12:00 am. I can
find no way to change this.
I am running Money 2005 basic.
Any help is greatly appreciated.
Did you have to have a Passport to download data from your bank?
...Dealing with Office 2007 & Office 2003 file formats
My company plans on moving to Office 2007 soon. However, we have a delimma
with how to handle how Office files are saved.
For example, if a person open a .doc & makes changes in Office 2007 and some
of those changes are not supported by the .doc, then the file is saved as a
..docx. This leaves us with two files... a doc & a docx. We really don't
want someone updating the .doc anymore.
Any suggestions on how to deal with this?
~We have the compatibility pack installed on all computers.
~The batch converter tool doesn't seem like a good fit for...cannot customize outlook Today #7
When user clicks on the "Customize Outlook Today" button,
noting happens. I upgraded his OUtlook 2000 to SP3. Did
a fix and repair. And renamed the outwvw.dll file to
when you go to properties of outlook today from the folder
list - home page tab - the restore defaults is grayed out.
any help is greatly appreciated.
See if this helps
"ilene" <firstname.lastname@example.org> wrote in message
> When user clicks on the "Customiz...Have 2004 and 2005 dates in worksheet
I've got Excel 2002 SP3. I have an ad schedule that lists closing dates for
2005 magazines. Some of the early 2005 issues (January and February) close
in November and December 2004. March and subsequent issues close beginning
in January 2005. I put the closing dates in the cells as 11/16 and 12/16
for Jan-Feb and it automatically adds the 2004. When I enter 1/16, I want
it to add 2005 instead of 2004. Can this be done? Thanks.
If you type only the month and day, Excel assumes the current year, as
described in the following MSKB article:
http://support.microsoft.com/d...Formatting Problem #2
I have a concatenated formula in cell A1 (contains both text and numbers).
I am trying to format the cell, right justified, with spaces to the right of
the value displayed.
I have been successful by formatting the cell as @" ".
However, when I format the cell in this manner, I can no longer modify the
formula and have it entered as a formula. When I remove the formatting, I
can then modify the formula which now is a working formula, and then format
it again as above.
This of course seems very strange, so I must be doing something wrong by
formatting with @" "....Border lines on the side of the date cell partially missing
Outlook 2003 (version 11.8118.8107) on XP SP2 Pro. As of few days ago my
Calendar appears with the border lines on the side of the date cell
partially missing. They are white or gray roughly the height of the adjacent
date number, while the rest of the line is OK (black). Any ideas?
I'm trying to picture this...can you give me a little more
What view are you using? (monthly, daily, etc)
Which side? (right, left)
Could it be that you have an appointment booked during that time?
"Jerry" <email@example.com> wrote in message