reformatting numbering of auto-numbered lists
I'm copyediting a medical book containing hundreds of short auto-numbered
lists (1-10 items length). Each number is currently followed by a period
which I'm required to remove throughout the document. I wonder if anyone can
come up with a macro to automate the process and save the tedium of having
to do each list manually. I've already tried F&R and found that it handles
only the manually-numbered items not the auto-numbers.
to convert the auto-numbers to text. You can then use F&R.
Hope this he...Cell Format
Would it be possible to limit the number and format of the characters
entered into a cell? For example
XXX 12345 /XX. As you typed the X's and numbers would be replaced and the
"?' preserved. Maintaining the spacing is what is most important.
Excel doesn't have an input mask feature similar to the one in Access.
You could use three cells for data entry, and use data validation to
control the data in each. Then, use a formula in another cell, to
combine the data and the necessary spacing.
ANDREW MC wrote:
> Would it be possible to limit the number and format of the ch...numbers need to be numbers
I exported a spreadsheet from a website using their export link, using MS
2007, it has hundreds of cells with numbers, I need to make charts, but, even
though the characters look like numbers they are not recognized as numbers.
I tried selecting/changing format. I tried entering 1 as a number in a
different cell, made sure it is a number, copied it, and did
The only thing that works is to create a new spreadsheet and hand enter the
numbers, and there is not enough time.
>a spreadsheet from a websit...what is maximum number of colums in worksheet?
I am trying to make a timeline for all of 2005, Jan-Dec. I also need to
include 6 colums of -data related to each day on the timeline. I now have to
worksheet dividing the year in-half, with some overflow added to each
section, Jan-Aug & Jun-Dec.
Can I get all of this on one worksheet?
365 days at 6 columns per day gives you in excess of 2000 columns which is
nearly 10 times the maximum number of columns you can have (256 is the max).
You will need to consider transposing your data, albeit timelines don't
always work nicely when vertical.
Ken...............Converting numbers to text?
Here is what I am doing:
I am opening some files in textpad(mainly because it will open and
concatenate multiple files) and then sorting the data without deleting
dupes. I then copy that data to excel and import as text. My problem is
that there are several cells that have .01 and .010 extensions that
excel still treats as the same even though they were imported as text
and it throws off my sumIF formula. Has anyone had this problem, and if
so please help?
apoc330's Profile: http://www.exce...intergrating row number into a formula
Here's another one. I want to pull a value out of a certain column
based on the row that the formula is in. For example:
-The desired value is in A column (number value)
-The row() function will return the row that the formula is in
-Lets say row returns 13
-I would like to retreive the text value in A13 dynamically using row()
within the formula.....something like
-The "5133" would be the text value of the number from A13 as determined
Sorry if these are noob ques...reprot/query problem
How do i go about adding a parameter query to a report deisgned to make
labels so that i get certain criteria in the report?? have tried record
source haven't had much luck with it.
...Sum of mixed leters and numbers.
Hello I am trying to add sums in a table that contain both numbers and letters, such as
these are listed multiple times. I am searching for a formula that will extract the amount of times each one is used in a cell. I would appreciate any help people are willing to give.
if you want the count of the entire cell content try
or try creating a pivot table for this
>Hello I am trying to add sums in a table that contain
both numbers and letters, such as
>thes...Convert number with comma to number with dot
Is there an easy way to convert "1.12" to a number, if your system is set
to use the comma as a decimal separator?
The value() function does not appear to take a format or locale as
The other way round is easy, with text() you can specify the format.
The problem occurs if you import an English web page into a Dutch
Just select the cells and do a Find & Replace changing . to ,
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Wessel Troost" <firstname.lastname@example.org...Cheque numbers
When we run "Vendor Cheque Register Report" we get a number of cheque
numbers such as REMIT000000000999 etc. with zero amounts. Can't figure
out where these come from although they seem to be related to manual
payments not cheques form Select cheques. These REMIT cheques are
repeats of manual cheques on the same listing (we think) but with a
different audit code and a zero balance. Can anyone tell me where this
REMIT cheque number comes from and or how it can be over written or
The REMIT is for ACH checks.
"noyb" <email@example.com&g...Sorting page numbers
Is there a simple way of sorting pages back into numeric
order after building a large spread sheet so they appear
in ascending order on the monitor.
Without renumbering that is
Your question is not clear to me, so here are three interpretations
even if it is a stretch compared to even what you indicated.
If you sorted the rows into a different order and want to restore
them you can restore the order if you previous numbered your
rows by placing a 1 on a new column (helper column) and
used the fill-handle to place 2 into next cell, and 3 into next, etc.
If you mean...numbering a column
I am trying to get a column within a table to number down the column. All
the numbers are coming up "1" instead of 1,2,3...
I have selected the column, format, bullets and numbering and this is what I
That's probably because you are using different cells for each number.
Publisher is not Excel. It does not automatically go to the next
number/letter/date/whatever. You'll have to change them manually or enter
them manually from the start.
MVP Microsoft [Publisher]
"cathy" <firstname.lastname@example.org> wrote in message
news:F...Sorting Numbers with Multiple Decimals (cont.)
I am attempting to create a file system using excel that can be easily
searched and sorted by a number ie 1.3.12 or alphabetically. At this time I
have entered the data as I would like it to appear if sorted by number,
however if I attempt to alphabetize I can not restore the numbers to their
Currently I have only 3 columns. One with numbers, one with file names, and
one with additional information. With the numbering extending to 8 numbers
Here is a more detailed example of what I have.
1.1.1 Bob Marketing
1.1.2 Jan I...passing record number to a form..
I have a form that shows customer records and I want to open another form
but pass the number of the record thats showing on the first form..
Im assuming i use the following basic code
but i dont know how to get the value of the current record number..
but i dont know
"Craig Armitage" <email@example.com> wrote in message
> I have a form that shows customer records and I want to open another for...Total number of items in a sale should be displayed in POS screen
Before you tender a sale it is always a good idea to compare the number of
items the customer is purchasing to the number of items rung in. If your
customer is buying 10 items and only 9 have been entered, you want your
salespeople to know this. RMS does not display the total number of items in
a sale anywhere in the POS screen so verifying that all items have been
entered is difficult and therefore not done.
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&qu...Change number format from text to number?
Using Excel 2002, WinXP
I was given a spreadsheet with a very long column of numbers. Each cell
displays the little green mark in the upper left corner. The dropdown arrow
shows "number stored as text." When I then choose "convert to number" the
number converts from text to number, which is what I want. But I don't have
time to manually change each of the 6,000+ cells. If I highlight several
cells, and do Format/Cells/Number/Number, the green mark in the upper left
corner remains and the numbers in the cells are NOT converted to numbers but
remain as text.
...Query Based DL
I have created a few query based DLs, should these appear in the default
global address list?
I created a new AL which i can use to show these, but the question above
You need to add the following string to your GAL's ldap filter:
The following post shows you how to do this for the All Groups address
list - you can similarly modify the purportedSearch attribute of your
default GAL as well to make them show up:
All Groups address list and Query-Based Distribution Groups
http://exchangepedia.com/blog/2005/12/al...Include a number of record in all views and search results
It is a huge gap in the CRM functionality when a user cannot see a total
number of records he/she is dealing with, whether it is while looking at a
view or performing a search (how many contacts do I have in the state of New
Can someone explain why CRM does not have this very common function? My
users say: "Our old Access database had it!" What do I answer them? CRM is so
advanced that it does not need this functionality? Export your results to
Excel every time you need to know your numbers?"
This post is a suggestion for Microsoft,...Determine Number of Characters in a Row
I have a spreadsheet that contains network information. I am trying to
determine the number of times a specific letter appears in a row. Is
there a formula that will look for that letter, count the number of
times it appears in that row and then input it into a specific cell?
Message posted from http://www.ExcelForum.com/
"t2true" <firstname.lastname@example.org> wrote in message
> I have a spreadsheet that contains network information. I am trying to
> determine the number of times a specific letter appe...How To Stop Acces From Update The Record When The Subform Query Is On Focus?
I need to know how to stop acces from update the record when the
subform query is on focus?
Chipcom <email@example.com> wrote:
> I need to know how to stop acces from update the record when the
> subform query is on focus?
If you mean that you want to keep the main form's record from being
saved when the subform gets the focus, the only ways you can do that
1. Have the main form be unbound. In that case your own code has to do
the job of reading the record, assigning its field values to ...I want to sort, ignoring all characters except numbers
I have a need to sort, a column, with cells that contain both
letters/characters and numbers. When the cell has a combination of
characters and numbers, I would like Excel to ignor any character that
is NOT a number and then sort the cells.
Example of data
The above example 'shows' the resulting sort that I am looking for. I
need to keep the data displayed with the extra characters.
Any help out there?
You can use a "helper" column to extract the numbers with a text formula,
and then select the original *and* the "helper" column, and s...Applied numbered styles change
I have a converted Word Perfect document. I modified Heading Styles 1 - 8 to
reflect what I need. When I apply heading style 6 (a numbered style), if
there are six lines of text, the first line (paragraph) is always aligned
differently the actual style itself. Subsequent lines are fine. Adjusting
the first line margins is counterproductive as it defeats the purpose of
using styles if I have to fix a particular heading throughout the doc. Also,
if I adjust that line and update the style, everywhere I have applied that
style, renumbers and is continuous throughout the documen...After Add Record, Put Cursor in specific Text Box
Hi, I had the wizard set up a button to add record (it puts in the code
below in the On Click property of the button). I'd then like to have the
focus go to text box [ProjectType]. I don't know how to do that. TIA :)
Private Sub cmdAddRecord_Click()
On Error GoTo Err_cmdAddRecord_Click
DoCmd.GoToRecord , , acNewRec
Private Sub cmdAddRecord_Click()
On Error GoTo Err_cmdAddRecord_Click
If Me.Dirty Then Me.Dirty = False
If ...replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER
I am importing basketball stats from another site. No problem until I import
the Free Throws Made/Free Throws Attempted stats. Here each cell contains
two numbers separated by a dash ... for example: 17-24 indicating 17
successful free throws were made out of 24 attempts. Since future
computations involve using only the Free Throws Attempted number, I am
interested in importing only the second number. What process must I go
through to accomplish that? Obviously I am new to Excell and will be most
appreciative of any assistance you can give me.
This formula will strip it out
=RIG...Convert to Number
I appologize for the re-post, I should have put this here originally...
I'm filling an excel (2003) worksheet using the 'Excel Files' DSN through
ODBC. I can get the data into the spread sheet no problem, but some of the
data cells have the little green info triangle that says 'The number in this
cell is formatted as text...'. When this happens, the formats I applied to
the column (currency, percent, etc) don't work.
I've made sure there are no extra characters during the input, I've used
Val() and CDbl() during the input, and I've tried a couple other o...