PUTTING NUMBERS IN A CELL
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN
Please turn off the CAPS Lock, more than two lines would
be extremely difficult to read. Reading caps is annoying.
Format the column as text, if the leading zero is important to
you then it is an identification not a number. The default
alignment for text is left aligned which is also better for
most identification "numbers".
Credit card numbers are 16 digits, are identification and
can not be entered as numbers, ever, because Excel only
retains 15 si...Column Search
I would like to know if it is possible to do the following in Excel
I have a number of columns of data which are used by various
My latest dilema is how do I find the first occurance of two different
numbers in two column of figures and match it with a value in an
adjacent cell; which will be the result of a formula.
In other words I want to find the 1st occurance of 1234 in column A
along with the first occurance of 789 in column B and where they match
return the value in column C.
Hoping for a speedy solution ...thanks
-----------------------------...Mailbox name not changing
Found a user recently with an incorrect mailbox name and tracked it
back to the AD object having the incorrect surname.
This was then changed but the mailbox did not update unless we did it
manually by re-resolving her login through profile settings etc
Is there anyway of setting this up as an automatic process?
On 16 Nov 2006 04:50:05 -0800, "email@example.com"
>Found a user recently with an incorrect mailbox name and tracked it
>back to the AD object having the incorrec...Lost Purchase order going over to Quick Books
Does anyone know how to see a report that contains purchase order information
on what is contained in a batch that goes over to Quick Books? We closed a
purchase order and it never went over to quick books after batch out. I went
to knowledge base and pulled up "You cannot export a closed purchase order
from Microsoft Point of Sale to Intuit Quickbooks (899318) but the directions
to do the workaround make absolutely no sense, almost as if it applies to
another version of RMS store operations.
I know that you probably checked this , but just in case....A note:
Double check...Microsoft Management reporter migration from Frx
I ran the Microsoft Management Report migration wizard. Several reports
have an entry in the Row definitions for CBR as a format code and in the
"Related Rows" and entry for 195 the row for our Net Sales.
In the column definitions we have a formula of B/CBR%. CBR% is generates
an error that % is an unexpected character and removing the % I get an error
that CBR is not a valid cell reference.
The help file seems to indicated that BASEROW should replace CBR but BASEROW
is not a selectable option in the Row definitions as a format code.
...How to copy the function SUM but offseted in 7 columns
I Have the folow situation :
The cells content is:
A1 = 50, B1 = 30, C1 = 40, D1 = 10, E1 = 20 and F1 = 10
Using the function SUM in the cell A4 = SUM(A1:C1) I have as a result 120
If I copy the cell A4 to B4 my SUM function will be B1 = SUM(B1:D1) and the
I would like to know how can I copy the SUM function from Cell A4 to B4 but
the SUM function should be SUM(D1:F1). And if a still copying to left side, I
mean to columns C, D, E... It should set the SUM functional to jump in each 4
A4 = SUM(A1:C1), B4 should be sum D1:F1, C4 should be sum G1:I1 ...
Regard...Search within a part of a column
I got a small question, which should not be any problem for a Excel
I want to search through a part of a column (i.e. "E200:E250") for a
specific text (i.e. "P"), and if in one cell of the specified range
exactly this text is found, I want to set a seperate text (i.e. "B") in
another cell (i.e. "E255).
Has anyone of you some idea for me?
I tried like =if(E200:E250="P"; "B"; ""), but is not working!
On occasion I get what feels like a crash -- in the
middle of an excel session after a refresh or something I
will get a 2-3 inch column of gray on the left side of my
excel workbook. I can still move around, save, use the
functionality, etc. but there is this gray area I can't
see through. This view will remain even if I go to any
workbook I have opened in this session of excel -- so its
not a workbook problem per se. The only way to get rid
of it is to go in and out of excel. Has anyone seen this
or know what it is? Thanks,
In the absence of other replies ........ th...Can you put white space outside a textbox?
When I put pictures in my publisher file, sometimes I want captions
for the pictures. So I make a tiny textbox that I put under the
picture, and type in a caption into that textbox. The problem is that
I can make the picture have some space to left and right of it so that
text doesn't crowd into the picture, but I can't do that with the
textbox containing the caption. Is there any way to prevent outside
text from crowding the borders of a textbox?
You can move that textbox wherever you need. You don't need to leave space
inside when you can steer clear of the textbox itself.
...Relative references to named range
On behalf of my newphew, I received this query:
"Quick one - I have a spreadsheet with very long formulas that reference a
whole lot of variables in the same column. I tried naming the cells so that
writing of the formula is easier to do. However, I need to copy the column
across for other entities of varying nature, and these copied cells refer to
the same named cell. Can I name a cell and copy it sideways so that it
retains some sort of name with allusion to the column that it is in?
Andrew van Gruting"
I have tried copying a formula with a named range and, as expected, it
maint...ID inquiry about numbers in column A
I have 6000 id numbers in column A and I have had to delete some rows
due to duplication.
This now means those numbers which were in order 1 to 6000 now have
How can I patch them up so that they are once again flowing from 1 to
See other post.
"rock" <firstname.lastname@example.org> wrote in message
> I have 6000 id numbers in column A and I have had to delete some rows due
> to duplication.
> This now means those n...VB script help to find columns and change...
Ok, I have 4 columns:
Department, Date, Employee Name, Daily HR attendance code
A, B, C, D
Headers are on row 1, everything below that is data...
So what I wanted to be able to do, is change the HR code with a script,
incase managers make a mistake.
So, first first the Date from B, then in Offset find the right name to
match the date, and then if those two match change the HR code using
offset on the same row.
starts here -------------
Dim lastrow As Long
Dim cell As Range
Dim txtDate As Date
Dim txtName As String
Dim txtHR As String
lastrow = Range("B6553...How do I make column C a percentage of column B
I need to calculate different percentages for fixed numbers I have in column
B. How do I make column C a percentage of B, column D a different percentage
of B, and so on.
not pretty sure what you want, you need column C to show percentage of B
based on a column B total ? if yes do
B100 = cell with the total
dopy formula down
if this is not what you were looking for please give an example thanks
> I need to calculate different percentages for fixed numbers I have in column
> B. How do I make column C a percentage of B,...Save record order in main table
I have a form which displays four field from a table. On the form I have 4
sort buttons which sorts the form based on the field selected. My table also
has a field for a sequence number. Based on the sort order selected I would
like the sequence number field for each record in the table to correspond to
the record number shown on the form. In other words, based on the sort the
first record shown on the form would get a sequence number of 1 in the table,
the second record shown would get a 2, etc.
Is this possible and if so could someone help with the code.
Your help woul...Where to put SQL statements in VC++ Application
I am wondering if putting all my SQL statements in the string table is
a good idea. Is there a better place to store these statements?? Thanks
in advance for any responses.
Inline in the code, they arnt particually helpful to put in the string
- Mark Randall
"Those people that think they know everything are a great annoyance to those
of us who do"
<email@example.com> wrote in message
>I am wondering if putting all my SQL statements in...Multiple Columns in a stacked column chart
Is it possible to create multiple columns of stacked data
sets? For example: can I plot monthly data in which each
month is the sum of 3 categories, but plot these stacked
columns for 2 years (side by side per month)? This
enables me to compare last years monthly totals versus
this years monthly totals on a per month basis?
Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.
There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/blie...Can't change a cell name back
I had a cell named "MP2OZ". It was supposed to be "ML2OZ" for
milliliters to ounces. When I noticed the typo, I selected the cell,
then clicked in the Name Box, and typed the correct name.
As soon as I did it, I realized that this would not change the
formulas that use that name. So, I changed it back (to MP2OZ) and then
opened up the Name Manager (Ctrl+F3) and tried to change MP2OZ to
ML2OZ. The Name Manager says that both the old and new names are
already in use and to choose a different name.
But the Name Manager only shows the one name (MP2OZ). It does not show
ML2OZ....Unwanted change in width of columns when showing formula.
When selecting to show formulas in cells, a lot of my columns change their
I have confirmed that I am viewing the worksheet at the same zoom-level
before and after switching to showing formulas.
When reverting back to show the actual results of the formulas in the cells,
the width also goes back to what I had initially decided on.
Why is this (width gets bigger)?
I want to have the freedom to maintain _my_ chosen column-width,
stupid-looking as it might be. Is there a solution to not have the
column-width changing like this?
Thank you in advance.
The column widths change because E...Comparing 3 columns?
How do I compare a value in one cell, to a value in a column, that looks at
the value in the adjacent column, to display in a cell?
For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.
Does anyone know how to do this?
Remember to Click Yes, if this post helps!
> How do I compare a value in one cell, to a value in a column, that looks at ...column labels repeat in excel
how do I make the column labels repeat in a spreadsheet? When I follow the
help directions, I am unable to "enter the row numbers" I keep getting a
message that it is an invalid entry. What am I doing wrong?
Try this, Karen:
"Karen" <Karen@discussions.microsoft.com> wrote in message
> how do I make the column labels repeat in a spreadsheet? When I follow
> the...How to Search two column value are match
I have two excel worksheet
One is Updated by local user , A worksheet
One is Updated by global user. B WorkSheet
When A worksheet completed, the Upload to B worksheet.
How to check two column value are matched by single Find command ?
Provide the ID and Item are matched.
Const GPD_RBO_COL = 2
Const GPD_ID_ADD = 5
Const GPD_ITEM_ADD = 4
Const GPD_DT_FMD_COMP_ADD = 10
Const GPD_STATUS = 19
'~~ For Master Workbook
Const GP_Sheet = "Digital Item Conversion 012709r"
Const GP_RBO_COL = 1 ' Update Field
Const GP_ID_RANGE = "V:V&...Put app and icon in task bar?
I have an MFC application that I want to be able to
put in the task bar as a small icon and have it pop
up the dialog when selected from the task bar.
This app is intended to be run from the start up menu
and be minimized in the task bar along with all the other
Pointers on how to please...
By default app goes on the task bar. Do you mean system tray (that by
default appears on the bottom right of the screen)?
Ajay Kalra [MVP - VC++]
"ShipHead" <GoAway@SpamBoy.com> wrote in message
> I...How to avoid name conflicts while copying sheets
i'm writing macros for an excel file.
i've a macro which will read the data from there are 30 to 40 work books
each work book contains 8 worksheets and copies that data
and paste the copied data into new workbook with corresponding 8 sheets.
it is copying the data into new work sheet. whats my problem is while coping
the data from all work books data it gives an dailog box.it gives an error
it shows the message as. i used same name in all 30-40 workbooks
"A formula or sheet you want to move or copy contains the name
Hi all. simple question.... how would i go about making column A
title column so when i move along, say to column z i can still see th
titles in column A. :confused
jhomer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2397
View this thread: http://www.excelforum.com/showthread.php?threadid=37596
Select column B
Does that help?
Ron Coderre's Profile: htt...columns show as numbers
I just noticed that all of my columns now show up as numbers instead of letters, which makes it difficult for entering formulas - how do I get the columns back to letters
Tools, Options, General, (uncheck) R1C1 reference style
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
"jbv" <firstname.lastname@example.org> wrote in message news:B43F64D5-7296-43AB-A137-98F623BC5236@microsoft.com...
> I just noticed tha...