[Fwd: Re: How to not copy the numbering from numbered list in Word ?]
By temporarily disabling the numbers and bullets in word before
you copy and paste the text. Then you can simply close the word
document (without saving it) so that no changes in the word file
That one time call girl may suggest that you should use Tipex on
the screen to remove the numbers!!! You have been warned.
> Hi !
> I want to copy a numbered list in Word and paste to a text file.
> The numbers show up. How do I not copy the numbers preceding the
> items ?
> Thanks very much in adv...Formating Negative Figures in Brackets
In earlier version of Excel, we could get a specific format for presenting
the negative numbers in brackets and / or in red color. I could not find it
in the Excel 2007. This can be done in the Custom Format. I do not have
specifics for it. Can you give me the format for the same ?
Why did the Excel remove this useful and oft needed feature from their new
version, or am I missing something ?
The below might be useful
> Excel 2007
> In earlier version of Exc...column with numbers
Suppose, I have a two (or several) columns with numbers. I want to
analyze two or more columns in a different way, for instance I want to
know the growth in percentage and probably have some visual
interpretation (i.e. arrow up or down).
Is there an Excel plug-in or stand-alone software for this? If anyone
expirienced the same problem? I'm going to look for such a software, if
one have in mind some other "must-have" features that I missed?
> Suppose, I have a two (or several) columns with numbers. I want to
>...Custom header numbering
I have a question about formatting Header numbering throughout a new
document (Word 2007).
I'm trying to do the following:
1.0 Heading 2
1.1 Heading 2
1.1.0 Heading 3
1.1.1 Heading 3
2.0 Heading 2
2.1 Heading 2
2.1.0 Heading 3
So it's an outline numbered / multilevel list, where Heading 1 has no
numbering, and Heading 2 restarts numbering after a Heading 1 is used.
I haven't been able to figure this one out for myselve.
Can anyone help me on this one?
Follow the instructions at
I was attempting to post a batch that contained a transfer. The post failed
and I recevied a message that "The serial number does not exist for this item
and site". The items were moved from the source site to the destination, but
the allcoated quantites in the source site are now negative. Any ideas how to
Have you run the inventory reconcile process?
(Utilities - Inventory - Reconcile)
"Eric Capponi" wrote:
> I was attempting to post a batch that contained a transfer. The post failed
> and I recevied a message that "The serial number does not...Changing number to dates
When ever I try to paste the characters 6-16 or 4-14 for example it is displayed as a date. I have tried formatting the cells to read this information as text. it is always overridden and converted to a date. How do I paste this info and have it appear the way that I want? Your help will be greatly appreciated.
format the target cells as 'Text' or insert the values with a leading
> When ever I try to paste the characters 6-16 or 4-14 for example it
> is displayed as a date. I have tried formatting the cells to read
> this info...making a negative effect
I am trying to switch the black and white color of a tempalte for an
invitation from black background white lettering to opposite. any help would
dctakj <firstname.lastname@example.org> was very recently heard to
> I am trying to switch the black and white color of a tempalte for an
> invitation from black background white lettering to opposite. any
> help would be appreciated
Printing this on white paper will be expensive because of the amount of ink
Printing this in black paper will be (virtually) impossible.
Now that's under your belt,...how do i sum a total in excel with numbers and text 58kg + 60kg
I can't seem to find a formula to add a column of numbers that have text, e.g
50kg+60kg+75kg won't add - can anyone help
Whenever you need to use numbers and text together and also need
computations, use custom formatting:
Pick an empty cell and pull-down:
Format > Cells > Number > Custom and enter General"kg"
if you then enter 100 in that cell, it will appear as 100kg, but you can
still use it for computations.
> I can't seem to find a formula to add a column of numbers that have text, e.g ...rounding numbers
Can have have a particular spreadsheeet always round numbers upwards. For
25.3 would be 26?
Thanks for any help
On Tue, 4 Nov 2003 21:14:59 -0500, "Frafi" <email@example.com> wrote:
>Can have have a particular spreadsheeet always round numbers upwards. For
>25.3 would be 26?
>Thanks for any help
Look at HELP for the ROUNDUP and CEILING Worksheet Functions
You could use the ROUNDUP function
for example if A1 contains 25.3, and B1 contains =ROUNDUP(A1,0) will give 26
That should do the trick
"Frafi" <frafi@...Negative Expenses
I'm using Money 2007 Premium but have had this problem in the last several
versions as well. Why is it that if I record a negative expensive, it is not
reflected in the reports?
An example: Let's say I go out to dinner with a friend. We receive the check
and I pay by credit card and my friend pays me with cash to cover his/her
part. I record the restaurant in the Food: Dining Out category in my credit
card account and then record that I received the cash in my Cash account and
classify it as a negative expense to the same category. However, when I view
the reports, only the pos...Assign random numbers
I have a table with roughly 40000 records, that gets more records added
weekly. From this table my staff work through each record and add a closed
date when finalised. The table the staff are working off contains an
"Investigated By" field which is linked to the staff members name on a
seperate table, the default investigated by name is "Exception". At this
point, only one person can work on the records at a time. The amount of
records that get added weekly varies and I want to be able to allocate an
employees name to each new record so that they show...Page numbers in Word
Operating System: Mac OS X 10.6 (Snow Leopard)
I cannot get Insert Page numbers to work in word, in documents elements when I choose Header, in other words, in any format.
When I select Insert, etc. I get a grayed button reading "page" instead of the numbers. I even had an email response from Microsoft but their instructions did not correct the problem. They had me put several items in the trash, and finally restart. Nothing worked.
It sounds to me like you simply may have toggled the display of Field
Codes -- Try keying Option+F9 or go into the Head...Entering Numbers in to cells
Is there a way to get Excel to warn you if you/not allow you to enter
number into a cell that is smaller than 0 or greater than 10
Message posted from http://www.ExcelForum.com
Check out Data Validation in XL Help (one topic: About setting
restrictions on cells and displaying input and error messages)
In article <Binkx.firstname.lastname@example.org>,
Binkx <<Binkx.email@example.com>> wrote:
> Is there a way to get Excel to warn you if you/not allow you to enter a
> number into a cell that is smaller than 0 or greater than 10.
data>validation>...Count number of records after filtering
Probably a question that's easy to answer but I have been searching for
hours now & it's driving me rather crazy: I have applied a filter to a form
and now I want to know how many records I have got as a result, or better, I
want to know if there are any records left - how do I do that?
Tried so far:
If Form.Recordset.Count = 0 Then ...
If Iserror(Form.RecordSet.Count) Then ...
If EOF(Recordset) Then ...
but that all does not work.
An easy way is to add a hidden text box, txtCount say, to the form, with a
ControlSourc...convert number to text #4
How can i convert a number to text format without then editing that cell to
force the cell to except the format change.
I need a numbers to convert to text because a download from another program
is already in text format with SS# in the cell. Then using at templet sheet
with a VLook Up formula to pull information off the first workbook.
To convert number to text, select the area you want to convert, right-click
on format cells and choose "text".
> How can i convert a number to text format without then editing that cell to
> force the cell to ex...Negative Zero?
Sometimes when I subtract a number from itself, I get a negative zero, rather
than a simple zero. Why is this?
probably a small diff somewhere in the 15 digits of the number
"Herbert" <Herbert@discussions.microsoft.com> wrote in message
> Sometimes when I subtract a number from itself, I get a negative zero,
> than a simple zero. Why is this?
It means that your result is less than zero, but not within the precision
you are displaying. For example, ...number format
my numbers are formatted using question marks, so i can center them
and still justify them by the decimal point. for ex. a column of
numbers with 2345678 being the largest of them, will be formatted with
this way i can center the column, and all numbers will straighten to
the right, by the decimal point. zeros appear as hyphens.
the problem is with the minus signs. if on the previous example i will
have -2345, it will look like this: - 2,345 (the minus sign away
from the digits).
any suggestions? i still wish to center the column. if i give this ...Number of Columns
We are using Excel 97, and we need to know if there is possible add more
columns than the 256 that already are available from A - IV.
We need that because we are exporting data from one aplication to Excel.
Thanks a lot.
no, 256 is the limit.
you may be able to use ms query to 'query' the data source and select
only the colums you need, or to build separate queries that return the
data over multiple sheets
No, 256 is all there are,
"Pedro Mestre" <PedroMestre@discussions.microsoft.com> wrote in message
news:0FBBBE2...Determine the number of bits in a negative number
I'd like to determine the number of bits (the position
of the highest on bit) in a negative number (say -1)
without using knowledge of its type.
Valid operations would be AND, OR, XOR, negation,
and one's compliment can be done as:
'Get a -1 of the same type as myvar
Dim minus1: minus1 = myvar - (myvar + 1)
Dim onesComp: onesComp = myvar XOR minus1
You could also use multiplication or division by 2
or other mathematical operators/functions, but
then sign extension comes into play.
The standard solution is to presume the answer
given the type of the variable, but...Pivot Table
I have a Pivot table with some numbers in it. Is there a way to
replace the numbers with a text?
For example: replace all numbers >1 with "yes" . Is this possible? If
not whats the best way to achieve this?
Only by changing your data source. Eg.
Dim rCell As Range
For Each rCell In Range("DataSource").Columns _
If rCell > 1 Then rCell = "yes"
"vinstream" <firstname.lastname@example.org> wrote in mes...Page Numbers #2
I have a 20 page booklet and am trying to get the page
number to not show on the last page which also is the back
cover of the booklet. Can anyone help?
>I have a 20 page booklet and am trying to get the page
>number to not show on the last page which also is the
>cover of the booklet. Can anyone help?
Go to last page, then under view on the tool bar click on
ignore master page.
...number of characters in POP
This client wants to be able to expand the number of characters for the item
description in PO Entry so that more characters will print on the purchase
But, when I go into Modify Current Window, I cannot find the field for the
item's description nor am I able to tell if it is possible to increase the
number of characters for this field.
Does anyone have any ideas on this? Perhaps, it's not possible to simply do
this with Modifier.
It is not possible to modify the length of the description field. However
this is what I suggest.
a. You could...Outline Numbering
I'm trying to outline number a report and have followed the guidance on
Shauna Kelly's page. However, my numbering is back to front - so it goes:
Instead of 1.2 and 1.2.1.
When I go into 'level 2' numbering, I can't link this to the previous level
- it selects it, then unselects it by itself. If I clear level 2 and start
again by selecting 'number style 1,2,3' then choose 'previous level number -
1' it puts the numbers together (11) and unselects the link to the previous
level. And when I put a 'period' in it...Quote product line should allow for negative extended amounts.
Quote product lines should allow for negative amounts. A situation where
this is required is when dealing with bulk discounts. We want the ability to
apply a product line with a negative value and have the overall quote value
reflect this change.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agre...Missing Transaction number
We are settling in to our first few days of closing, we are going over the
transactions and there a few missing numbers in the journal. How do we locate
them to deciefer our discrepency.
A few things to check.
Make sure all quotes, work orders, layaways, and backorders are checked to
write to journal. This could be accounting for some of the transaction
Also, make sure all tender types are checked to write to journal.
"Paul" <Paul@discussions.microsoft.com> wrote in message