Number of daysI connection with some (simple) interest calculation (where interest rate is
fixed every 1st July and 1st January and where interest calculation is based
on 360/360) I need to know how many days at which interest rate.
Let's say I have an amount which was due on 1st September 2008. Let's
further say that in A1:A5 I have:
A1: 1-Jul-2008
A2: 1-Jan-2009
A3: 1-Jul-2009
A4: 1-Jan-2010
A5: =Today()
E2: First day of the interest period
I have the following formula in B1: =IF(A1>=$E$2;DAYS360($E$2;A1;1);0)
(I use semicolon as separator)
Copied down to B5 this gives me:
...
Numbers changed to dates in cells
Hello,
When I input something like 12-4 into a cell it converts
it to December 4.
How do I format the cells so they will leave my entries
as is without converting them to dates or anything else?
Thanks!
Jeff
Jeff,
Format the cells as "Text" beforehand
Format/Cells "Number" Tab, select "Text"
or
place an apostrophy before entering the number
'12-4
John
Jeff wrote:
> Hello,
>
> When I input something like 12-4 into a cell it converts
> it to December 4.
>
> How do I format the cells so they will leave my entries
> as is without...
Checking Winning Numbers in the Lottery.For people who may not understand the lottery rules for the UK.
Person picks 6 numbers in the range 1 to 49 (no duplicates)
If all the 6 numbers come up then when the lottery numbers are announced,
then it is serious party time.
Problem: -
We have 25 people in our Lottery syndicate and therefore I want to automate
the checking of numbers that are announced with numbers that are pre-selected
by the 25 individuals. Additionally, I want to know how many numbers have
matched in an individual row against those announced.
E.G.
Assume lottery number announced (in ascending sequence are) 1, ...
Restart Outline NumberingVersion: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
I have created an outline that has multiple levels. In the outline numbering dialog box I have checked the box for "restart numbering after" for each of the levels 2, 3, and 4, and saved this in the template. <br><br>For level 2, the outline numbering does not start after level 1. However, for all subsequent levels, the outline numbering does start correctly. The box is correctly checked when I go in to review the settings for my outline numbering. I have tried to uncheck and sa...
use formula on external data rangeHi All,
I've got a problem with data I read from a database.
I wrote a VBA Sub in Excel 2007 with retrieves data via
ActiveSheet.QueryTables.Add() per OLEDB out of a database.
This works fine and puts the data in the range beginning on cell "A8"
Now my problem:
I have a formula '=SUM(A8:A10) in cell "B1".
This formula always comes out = 0, although there are values in the cells.
But if I edit cell "A8" without changing the value (just the alignment
changes) it is recognized and the formula shows = 1
What am I missing here ?
Thanks ...
Numbers will not copy between worksheets
I have an Excel workbook with two worksheets. One named Assests and the
other named Print. Users enter data on the assets sheet and then run a
macro that prints out the 'Print' sheet in a certain way. I have cells
on the Print sheet linked to cells on the Assets sheet with a formula
like this one:
=IF(Assets!B10>"",(""&Assets!B10&""),"")
This works great unless the value entered is just a number. If it's
just a number with no letters, the value from the Assets sheet does not
show in the corresponding cell on the Print sheet....
Get PCI Bus/Function/Device NumberHi All,
Is there a way to get the PCI bus, function and device number on which
my current driver is installed. I could only find bus number in
DEVICE_REGISTRY_PROPERTY. I had used WdfDeviceQueryProperty to
retrieve this data.
How can I get the function and device number?
Thank You.
Regards,
Sushma
Sushma <sushma.yella@gmail.com> wrote:
>
>Is there a way to get the PCI bus, function and device number on which
>my current driver is installed.
Why? That information is not very useful.
>I could only find bus number in
>DEVICE_REGISTRY_PROPERTY. I h...
IE toolbar questionHi,
anybody knows how to make toolbar after installation/registration to appear
on
IE automatically, without having to go to view/toolbars menu and checking it
out ? I couldn't find any trace in IE registry settings.
thanks
Open a new browser instance than using the IWebBrowser2 interface from that
instance, show your browser bar by calling ShowBrowserBar. After that the
setting will stick.
AliR.
"andrew" <kc2ine@yahoo.com> wrote in message
news:u4M1g8RRFHA.356@TK2MSFTNGP14.phx.gbl...
> Hi,
> anybody knows how to make toolbar after installation/registration to...
csv import into excel, preserving leading zeros in numbersHi,
We have csv file automatically generated where rows look like:
"0123","04567","089".
The problem is that when Excel opens this file it puts it into cells like
123,456,89
stripping leading zeros. Is there way to generate csv file so that leading
zeros won't be stripped so it would like
0123,0456,089 when the file is opened in excel.
Thank you
Vadim
Hi Vadim,
rename the file a .txt file. Then you will have a choice for the type of
field, number or text
--
Kind regards,
Niek Otten
"Vadim" <vadim@dontsend.com> wrote in message
new...
max numbermay anyone tell me how to find the largest number within a heap of numbers??
On Mon, 24 Nov 2003 00:44:43 +0800, "vivats" <vivats@netvigator.com> wrote:
>may anyone tell me how to find the largest number within a heap of numbers??
>
=MAX(Heap)
--ron
=max(rangeof heap)
vivats wrote:
>may anyone tell me how to find the largest number within a heap of numbers??
>
>
>
>
Assuming the "heap" is a range........
=MAX(A1:A10)
Gord Dibben XL2002
On Mon, 24 Nov 2003 00:44:43 +0800, "vivats" <vivats@netvigator.com> wrote:
&...
SOP NonInventory Unit Cost 6 Decimal PlacesIs there any simple way to increase the currency decimal places to greater
than the current highest value of 5?
Thanx
Scott,
I don't believe there is any easy or even moderately difficult way to do
this, as the field types used to store amounts in GP only go up to 5 decimal
places.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com
"Scott Rutledge" <sersoar@hotmail.com> wrote in message
news:E102B81B-8555-400E-843C-240C58794294@microsoft.com...
> Is there any...
Number Field in TableCan I stop a record being saved if the number is 0 in a number field in my
table?
--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3
I suppose >0 in validation rule would do it?
"Bob Vance" <rjvance@ihug.co.nz> wrote in message
news:ePHbBqiqKHA.4752@TK2MSFTNGP04.phx.gbl...
> Can I stop a record being saved if the number is 0 in a number field in my
> table?
>
> --
> Thanks in advance for any help with this......Bob
> MS Access 2007 accdb
> Windows XP Home...
percentage breakout from listNeed to create a chart showing where time goes by time, and would like the
percentage for each category along with piechart.
just use the chart wizard. the pie chart option in has a "show percentage"
setting
...
Help with SetWindowsHookEx (newbie)Trying to trap messages from another process.
I have already inserted a new menu item into the process, now I'm tryign to
trap messages with with the following code:
GetWindowThreadProcessId(HmbWindow, &threadID);
HINSTANCE hModHnd = GetModuleHandle(NULL);
g_hHook = (HHOOK)SetWindowsHookEx(WH_GETMESSAGE, (HOOKPROC)MyHookProc,
hModHnd, threadID);
g_hHook is always NULL. I'm not sure why, I have checked everything I can
think of to check and it all looks fine.
Here is what the MyHookProc looks like:
LRESULT CALLBACK MyHookProc(int code, WPARAM wParam, LPARAM ...
Change a positive number to negative number
I have a column of positive numbers that I need to change to negativ
numbers. Is there an easy way to do this? Right now I manualy make th
change. Thank you, Pa
--
patowen
-----------------------------------------------------------------------
patowens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=38155
patowens, put -1 in an empty cell, copy that cell, select the numbers you
want to change, right click and paste special, check multiply, OK.
--
Paul B
Always backup your data before tr...
How do you sort words in Excel by the number of letters in a wordI have a list of 5,000 words that I need sort by the number of letters in the
word for my students is this possible to do? The words range from 1 letter
to 9 letters in a word.
with the use of a helper column
=LEN(A1)
if you do not want to count spaces
=LEN(SUBSTITUTE(A1," ",""))
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Kinger" <Kinger@discussions.microso...
Need solution to formula problemHelp please!
I have two rows of numbers with some cell that will contain 'N/A".
If the top row is highest I need it highlighted yellow if it is not highest
or is "N/A" the cell needs to remain with no fill.
I can do a condtional formatting that works great until a cell contains the
"N/A". Is there a formula that I can do in conditional formatting or some
other options that will solve this problem.
As suggested in your multi-post in .programming
(please do not multi-post)
Try this ..
Select rows 1 & 2, and apply cond format
Cond1's formula: =A$1=&q...
Internet header questionDoes anyone know of any tool that could be ran against an outlook
folder full of internet mail that would extract the SMTP address sent
from for all of them and export it to any format?
I'm going through spam from various users, and between the firewall
and the antivirus software on my exchange server I want to add the
IP's to a block list. But it's a pain opening them one at a time,
getting to options, copying the IP, and pasting it into an excel
spreadsheet.
Thanks for any suggestions.
John
JDTHREE [MVP] <john@removeforspam.engagenet.com> wrote:
> I'm going th...
How do you turn off the page numbering/header/footer command?I turned on the page numbering command in Word 7 intending to number the last
two of four pages as 1 and 2. When I could not get that to work and wanted to
turn the command off and get back to the document, I could find no way, even
using the on-line help feature of finding out how to do so. Please advise!
Word 7 is Word for Windows 95. Presumably you are referring to Word 2007.
You can't just turn off or restart page numbering for specific pages. You
have to insert section breaks and proceed from there. See
http://word.mvps.org/FAQs/Numbering/PageNumbering.htm.
--
S...
Reduce currency decimalsHi,
Is there any tool which will reduce the currency decimals on our Great
Plains system. We want to reduce our system currency decimals.
Thank you.
KT
I'm not sure if this is what you mean, but there's
Tools >> Utilities >> Inventory >> Change Decimal Places
This utility can change the decimal places for items.
I don't know of any system-wide change for decimal places.
Eleni
"KT" wrote:
> Hi,
>
> Is there any tool which will reduce the currency decimals on our Great
> Plains system. We want to reduce our system currency decimals....
decimal problemHi all
I a very strange effect when using different decimal settings
and calculating some values:
DECLARE @Decimal1 decimal(5, 2)
DECLARE @Decimal2 decimal(30, 2)
SET @Decimal1 = 0.2
SET @Decimal2 = 0.2
SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal1))
SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal2))
The first result is correct (0.00000000025832000),
the second is wrong, why ???
Thanks for any comments
Best regards
Frank Uray
Hi Frank
This is what happens when you multiple these precision&scales
Precision
15 + 3...
Microsoft Money 2004 Standard Online services questionHi,
I am thinking about buying Microsoft Money 2004 standard. I bought
quicken last year mainly because out bank supported transaction
download only through quicken. A year after buying it the online
service expired and I cannot even manually download and import
transactions unless I renew the service. It is cheaper to buy a new
copy of money standard then to renew the service in quicken. My needs
are fairly simple so standard would do but I am wondering how long the
basic transaction download services lasts in Microsoft Money. Our bank
now supports both so I can go either way. I have not bee...
formula or VBAI need to search through a column checking condtions. If the conditions are
met, then I want to enter the corresponding value in the column next to it
into a different cell. Basically, I want to search column A and, if the
conditions are met, put the value in B into C. Would this be easier via
formula or code? And maybe some starting suggestions would be nice if you
don't mind.
--
Thanks,
Jim
in a formula in col b
=if(cond,a1,"")
using vba
for each c in range("a1:a100")
if cond then c.offset(0,1)=c
next
--
Don Guillett
SalesAid Software
donaldb@281.com
"...
** Few QuestionsHello all..
Few questions, and thank you for your help!
1 - How can I set up an email add. to forward to a AD
users mailbox? For example, if joe@msn.com wanted to
recieve all emails addressed to resumes@msn.com. *Without
creating an AD user and forwarding the email*?
2 - Is there a way to create a contact list in Exch'03 for
all staff to use? ex. When the user opens Outlook 2003,
he/she will have the all staff contact list available.
3 - I know theres a 16GB limit when using Exch'03
Standard, but should I worry if no one is storing their
mail on the server? If everyone store...
lining up numbers on calendar?This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C91045.3F6FA900
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
As I was setting this up, I thought it sounds kind of picky (LOL)
There are probably other templates that do more what I want, I just got =
to using this one. (I usually use the "understated" one and adapt it to =
what I want or think will work good)
On this one (Varsity- Pub 2007) it seems like the numbers of the days =
are too far to the left under the names of the days up top.
It looks o...