I imported a bunch of records that include an item number that begins with
"0". Both the Excel spreadsheet cell and the Access table are marked as
NUMBER. Nevertheless, when the item are imported the leading "0" was deleted.
Why? How do I overcome that as I have to have the "0".
Am 02.06.2010 16:44, schrieb Kevin M:
> I imported a bunch of records that include an item number that begins with
> "0". Both the Excel spreadsheet cell and the Access table are marked as
> NUMBER. Nevertheless, when the item are imported the leadi...Auto Account Number Generation
Here's a newbie question for which I have not yet been able to find a
solution. Whenever creating a new account, I'd like the form to
automatically display an account number in the accountnumber field that is
one more than the max in the table. How can I automtically create this?
That is how can I run a query on form load that looks up the current max
account number then add one to it? ANy help would be appreciated.
Only way to do this is through writing some code. For example you could
achieve this using a callout. When you save a new account you can have the
callout scan ...Q: How to make "whole" numbers?
i want to tell excel, to make out of a number e.g. 5,93 a "whole number" (as
we call it in german), wich in this case would be 5.
please don't mix it up with ROUND. round would have made a 6 out of it.
what i want, is that all these numbers e.g.
would be turned into a 5
thanx in advance,
On Sun, 27 Jul 2003 02:45:25 +0200, "Tom H. Lautenbacher"
>i want to tell excel, to make out of a number e.g. 5,...How do I add numbers in visible cells using Excel 97
I need to add values in visible cells using Excel 97 using
a formula instead of adding values of each cell
If you mean your data is filtered, check out the SUBTOTAL function -- eg:
Support Boris - visit http://www.ncadc.org.uk/letters/newszine36/boris.html
If you are hidding the rows using a filter, then look in help at the
Subtotal worksheet function.
Other than that, there is no built in function that ignores hidden cells.
Perhaps there is a cell value condition you can check - so you could use
Sumif, use the c...Formula to find the last number of a column (lower cell)
I have a column with numbers. I want a formula that it will be finding the
lower cell that has data. For example in column A i have numbers in cells A1,
A2 and A3. In cell A10 i want a fotmula. With this formula will see in cell
A10 the number that i have in cell A3. If i put a number in cell A4 i want
that number to be shown in cell A10.
Try the below in cell A10
Jacob (MVP - Excel)
> I have a column with numbers. I want a formula that it will be finding the
> lower cell that has data. For example in colu...Number to Word
I want to enter "1" in cell a1 and i want "annual" to populate into b1.
Iwant to enter ".52" in cell a1 and i want "semi-annual to populat
so on and so on.
I want excel setup up so if i type 1 that it puts annual into a cell
Annual, semi annual, quarterly and monthly.
Is this possible??
8675039's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1633
View this thread: http://www.excelforum.com/showthread.php?threadid=27756
A VL...Emailing to a fax number
what is syntax for sending an email to a fax number?
That requires an email to fax service. Press CTRL+SHIFT+X in the main
Outlook window to start settings things up.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"ljc" <email@example.com> wrote in message
> what is syntax for sending an email to a f...Find cell numbers in a table so I can multiply
Hello, I have a word document and in the documents header there is a table.
This table a has diferent number of cells in each row like:
Row one: 2 cells
Row two: 4 cells
Row three: 2 cells
Row four: 10 cells
Row five: 2 cells
What I wanted to do is multipy 3 cells together thats in row four and show
the total in the same row. I have a number in the 3rd cell that needs * by
the number in the fith cell that needs * by the number in the seventh cell
and totaled in the 9th cell. I know I have to select the ninth cell and
select table/formula then what?
I ...Changing initials into numbers
I have data that I download into Excel and initials are used for different
people. I need to give those initials a number in excel for example MJ = 01,
HS = 02..etc. Thank you.
On 2/3/2010 9:26 AM, Kathie wrote:
> I have data that I download into Excel and initials are used for different
> people. I need to give those initials a number in excel for example MJ = 01,
> HS = 02..etc. Thank you.
see VLOOKUP in Excel help.
You have to be more specific. Where are the initials (column, row,
sheet)? Where do you want the numbers placed? HTH Otto
&quo...the number "3" displays like an exposant
je ne comprend pas pourquoi le chiffre 3 apparait comme un exposant dans mon
...Socket relared problem (getting free port number dynamically) #2
i have one problem related to thread. i am having my main thread
running which will
on some event create a thread for validation purpose and then will
and now this validator thread will create a socket and it will bind to
and then will wait for client to connect.
but before waiting for client to connect it will send a message to the
main thread that
validation is done.
but in this way i need to stick with port 20111.which i really don't
Is it possible for me to get a free port from operating system or from
library and then i should bind t...Number of users
Can anybody tell me the number of users that can use Excel at any one
point. I am fairly sure that a number of users can use it at once, but
will they have to look at the spreadsheet in a 'read only' state with
only one user having the full functions of the spreadsheet.
So basically, is it true that a number of users can use it, but the
spreadsheet is in a read only format?
any help will be most appreciated.
pompey_student's Profile: http://www.excelforum.com/member.php?action=ge...phone numbers #2
how do i add a new phone number field to the drop down
list in outlook?
You mean besides the 17 or so that are there? You can't add a new type of
phone number. Sorry.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"shauna" <firstname.lastname@example.org> wrote in message
> how do i add a new phone number field ...Formatting cells for big numbers and formulas ...without the formu
I am stuck with this: If I want cells to display like 20-digit numbers in
numerical form (that is, not the xxx+EXX way), formatting them as a text is
okay. But then I need to add formulas and want the results to be displayed.
But as the cells are text formatted, the result in the cell is of course the
text of the formula plus the number. So my question is - in a cell I want
e.g. "12345678901234567890-sum(A1,B1)" and I want the cell to display the
resulting number, not the formula itself. How do I achieve this?
The maximum precision for a number is 15 digits according to...entering numbers that begin with zero
I often enter manufacturer model#'s into my spreadsheet. If they begin with
zero Excel automatically the zero. What can I do to change this?
On Sep 10, 1:15=A0pm, Shannon <Shan...@discussions.microsoft.com> wrote:
> I often enter manufacturer model#'s into my spreadsheet. =A0If they begin=
> zero Excel automatically the zero. =A0What can I do to change this?
You can format the cells to accept leading zero's. From the format
cells window, look for custom number formats, then in the Type field
0000 , with each zero representing the number of digits you w...numbers not correct
When I try to add numbers to a cell, they are converted to a date. How can I
correct this? I have the "general" numbers tab selected. (Excel 2007)
Think you could either precede the entry with an apostrophe ('), or
pre-format the data entry col as text.
"Chicken Dogs" wrote:
> When I try to add numbers to a cell, they are converted to a date. How can I
> correct this? I have the "general" numbers tab selected. (Excel 2007)
...Add a number based on list of criteria ??
Example: Cell A = 50, Cell B = 96%, Cell C = Cell A + (Cell A x Cell
B) = 98
I want to be able to compare the list of criteria and add a number to
Cell C accordingly
For example: If Cell B is between 95 and 100%, Add 1 to the total in
If between 85 and 94%, add 2... etc.
There are more than 7 so I know I can't simply nest If statements...
Any advice on how I could fairly simply accomplish this?
Put your % bands in a table (say in J1:Kx, e.g.:
1 0 11
2 5% 10
3 15% 9
10 85% 2
11 ...Repeat values in column A a certain number of times depending on the value in column B
Imagine a set of data as set out below:
Column A Column B
I want to poplulate a column (for exampel column A on a new sheet),
where the values in column A will be repeated as many times as the
value in column B
Thus the first 24 rows will say Apples, the next 36 rows will Pears,
I need a formula that recogonizes that when it gets to row 25 that it
should no longer need to copy Apples, but then switch to pears.
This might sound like an unusual request but if I can grasp a way to
do this I can create the table I need and populate the rest...Newbie Help for Custom Number Formats
I am working on a spreadsheet that I would like to have it append the
inch symbol as part of the number format ("). I figured out that I can
add custom suffixes with the use of the quotation marks, but I can't
place a quotation mark inside of quotes and get what I need. Is there
any way to have Excel do this for me?
I know it seems like a small thing to do, but having Excel add this for
me would save me a lot of time with formulas and all.
Thanks in advance.
j...AUTO NUMBERING #2
hi all,i have made an invoice template for my work.how can i get these
invoices to sequentially number each time i use the invoice and save as iun
the customers name?any suggestions will be greatly appreciated. thanks wyn.
one way (using the Windows registry for storing the last number). Put
the following code in the workbook module (not in a standard module) of
- It changes cell A1 of the first sheet
- you may change the key identifiert according to your needs (e.g.
DEFAULTSTART, MYLOCATION, etc.)
Private Sub Workbook_Open()
Const DEFAULTSTART As Int...Calculating greatest number in a range
This is a little tricky to explain, but hopefully will make sense.
A series of data is produced that monitors concurrent users on a
system. This is returned every five minutes of every day.
This is on a work book which has a month for each tab.
Data typically comes in the following, simple form:
Wed Nov 26 10:50:01 GMT 2008 0
Wed Nov 26 10:55:00 GMT 2008 0
Wed Nov 26 11:00:00 GMT 2008 1
Wed Nov 26 11:05:00 GMT 2008 1
Wed Nov 26 11:10:00 GMT 2008 1
Wed Nov 26 11:15:00 GMT 2008 1
Wed Nov 26 11:20:00 GMT 2008 1
Essentially, I need a way of differentiating between indivi...Continue page numbering from previous document while Indexing
I have a very long document that I have split into several smaller documents
to work on and consequently, I have set the page numbering for each
subsequent according to the last page of the previous document:
"Document #1: Page 1-500"
"Document #2: Page 501-750"
"Document #3: Page 751-900"
However, when I do Indexing in Document #2, regardless of the page number I
have set up, it reverts to Page 1 when updating the Index and resets the
entire page numbering in that document. How can I 'force' the Indexing to
recognize the subsequent pag...macro to find phone number and label with text
Here's the situation: I have long lists of satellite phone bills that
I need to track by individual phone users and I want to build a macro
that seeks out a specific number (example, macro searches "882 156 445
4554" and in the column next to it, automatically spits out "Dan's
In one Excel file, I have a growing list of satellite phone numbers
(~400 numbers) that I'm constantly adding to that I'm hoping the macro
can draw from. In the other set of files, I have individual phone
bills for each phone (about 18 separate excel files per month) wi...numbers being rounded
a chart that i am making has two kinds of numbers, one set is prices and
another set is the codes that our system reads to apply the prices. the
problem i am having has to do with the codes. Some codes have to have a .0
(as in 678.0) and some have to start with a zero (as in 054). but as soon as
i click out of the cell the numbers are rounded to 687 and 54. but those
zeros are important to our system. i tried to mess with the decimal places
but it just didnt help. Thank you
> a chart that i am making has two kinds of numbers, one set is prices
> ano...inserting a number of rows by input in a cell
Is the following possible, if yes, how:
I want to fill in a number in a cell, which corresponds to the number of
rows that will be inserted on the next sheet on a specific location (between
row 8 and 9). The rows that are inserted must be filled with the same
formula's as the row(s) above (row 8). the number of rows must be dynamic.
Normally I would do this by hand:
- insert X rows
- select the two rows above those rows
- pull down the rows to create the same formula's
David McRitchie has a macro that almost does what you want.
Instead of using a cell to get the number of rows...