NUMBER FORMAT #9
CREATE A NEW NUMBER FORMAT SO THAT THE SELECTED DATES WILL APPEAR ONLY AS THE
FULL NAME OF THE DAYS OF THE WEEK.
...Copy certain cells in a row based on one coordinate
I have a few thousand rows of data and about 10 columns.
In a different sheet tab, I want to enter a coordinate(G22) in cell A1, and
in B1, I want to see the text in B22 of the other sheet.
I hope this makes sense.
I have a data sheet, and want to extract certain cells from a certain row
and place it in a different sheet to fax to a customer.
I was hoping there was a command to enter a cell, and cells from that row
would be entered in another sheet in a different order.
have a look at VLOOKUP if I understood you correctly:
Regards...Moving text from row to column in Excel
I'm working with a report from a web-based application that I cannot
export into Excel. I can copy and paste the text, but when I do that
all the text that is listed in columns horizontally ends up being
listed in the first column of my Excel file vertically. What I want to
do is select, say for example, the first 8 or so items in the list
vertically and have them move to the first 8 horizontal cells. Is
there an easy way to do this short of copy and paste? This is
something I may need to do on a regular basis and need a quick and
easy way to change the way this info is coming into Ex...deleting rows automatically using a maco or vba
I have a report that comes to me in Excel 2003. I need to remove the first 3
and last 3 rows. The report in between may vary on the number of rows
however. It is basically a repetion I want to forgo.
This assumes that col A is filled on the last row:
Dim n As Long
Dim s As String
n = Cells(Rows.Count, "A").End(xlUp).Row
s = n - 2 & ":" & n
Gary''s Student - gsnu201001
> I have a report that comes to me in Excel 2003. I need t..."the operation has timedout" error
I am getting the following error. Is it possible to increase the timeout
period of a web service?
Event Type: Error
Event Source: UKDynamics
Event Category: (6)
Event ID: 103
Message:- Failure occured during Synchronisation of Locations from XXXXX to
The operation has timed out
System.Web.Services.Protocols.HttpWebClientProtocol.GetWeb...Adjusting formula so it works even if some rows above empty?
I have a dollar amount in cell F23, say, with a formula in G23 to deduct
that from subtotal in G22. The formula in G23 looks like this:
This works great.
But I've run into a problem I need to adjust for and can't figure out.
These columns, F and G, from rows 18 to 31 are for miscellaneous
information. Sometimes I have amounts to deduct, other times it's just info
in the description column B to the left of F (there are some merged cells
there) about payments in the rest of the spreadsheet and no amount needs go
into column 2...FAILED OPERATION
publisher will not connect to outlook when sending email attachment
What version Publisher? What version Outlook?
The Send This Page as Message command is not available when you click Send E-mail on
the File menu in Publisher 2003
Mary Sauer MS MVP
"fits nicely" <fits email@example.com> wrote in message
> publisher will not connect to outlook when sendi...How to make repeating rows stop
I have a client with Excel 2002. She has row 7 set to
repeat. However after row 210 (which becomes a notes
section) she wants it to stop. Is this possible?
I don't believe this is possible.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Carla Bradley" <firstname.lastname@example.org> wrote in
> I have a client with Excel 2002. She has row 7 set to
> repeat. However after row 210 (which be...Sorting rows by identical value of columns
I have an inventory worksheet with 3 columns. Each of the columns
contains values that should exist in at least one of the other two
columns. We want to visualize the rows that contains values not
represented in another column.
The data in each column is sorted A-Z, but this does not show the
"gaps" where a value is not in one of the other columns.
A B C
1 PC1 PC2 PC2
2 PC2 PC3 PC4
3 PC3 PC4 PC5
4 PC5 PC5 PC6
We want this sorted by identical values on the "row axis".
A ...Dual cash drawer operation
I have a prospect that has a news and gift store, and also
sells lottery tickets. He would like to use a separate
cash drawer at the POS, to enable him to keep the state
money separate from other sales monies. He wants to kick
the second drawer for this transaction. Can this be
handled at the POS?
Thanks for the help. Ralph.
Hi Ralf :-)
Do they accept other tender types for these transactions
"can I pay with VISA for lottery tickets?"
I'm just curious... maybe Vince has some tips :-)
I know this isn't the answer you are looking for... but how about at the end
of ...HOW DO I GET A WARNING FOR REPEATED NUMBERS
I am working on a spreasheet in excel I have got invoice numbers but i need
to create a warning for repeated invoice numbers.Any help would be most
Try =COUNTIF(A:A,A1)=1, previously posted by Vishu
> I am working on a spreasheet in excel I have got invoice numbers but i need
> to create a warning for repeated invoice numbers.Any help would be most
Thank you Kassie,It worked!
> Try =COUNTIF(A:A,A1)=1, previously posted by Vishu
> "Kenya" wrote:
>..."Sticky" prices for parts in Store Operations
When we go into store operations, bring up a part and check it's price, then
go into another part - RMS seems to "remember" the last part's price. eg.
we look at, say, a bolt - it is $3.50, we close that, open up, say, a truck
(just an example) - this truck now shows a price of $3.50!
In POS where we do the invoices, it has the right price for the truck...
but we don't want to do an invoice when just looking up parts for a verbal
This is a strange one, has anyone else seen this or knows where I can start
This issue was fixed...Sorting does numbers in weird order
I was given a worksheet that I need to sort in numerical
order. The cells contain both letters and numbers (e.g.,
VL 1087). The problem is that it sorts them like VL 1, VL
10, VL 100, VL 1000, VL 1001, etc. VL 16 is after 159 etc.
Kind of like dewey decimal system without the decimals. I
have tried reformatting the cells to text, numbers,
general. Nothing seems to work.
The easiest way is to insert two temporary helper columns next to th
numbers column. Then - seperate the VL from the numbers, using Data
Text-to-columns. Now you have a number column you can sort by, an
a...Operator precedence (order of operate) =A1/A2*A3^5-(A1+A2)
what is the order of operating and calculating in this formula?
If it were me, I'd put parens in to ensure I get the calculation I want.
"Masood Shahab" <email@example.com> wrote in message
> what is the order of operating and calculating in this formula?
> 1- A1+A2
> 2- A1/A2
> 3- A3^5
> 4- A2*A3
Masood Shahab wrote...
&...Number of users per message store.
Does anyone know an easy way to calculate the number of ussers per
message store, other tan counting them seperatly.
in the ESM, you should be able to drill down to "Mailboxes", select them
all, and get a count down in the "status" bar...
Susan Conkey [MVP]
"Mark A. Dudley" <firstname.lastname@example.org> wrote in message
> Does anyone know an easy way to calculate the number of ussers per
> message store, other tan counting them seperatly.
On Wed, 24 Ma...You cannot perform this operation at the moment.There is an online operation in progress.
Do you know why is the following message appearings "You cannot perform this
operation at the moment.There is an online operation in progress.Please try
I have nothing running in the background. I am trying to import a file by
downloading from the web and then clicking "Open" button.
Some activity is in process, either the one you initiated or another one
Money piggy-backed on your request. Money does some auto-processing on
imported files, trying to match the file transactions to existing Money
transactions. It doesn't let you make any transac...Customer Item Number on Packing Slips, Orders, Quotes
I want to add the Customer Item Number on my reports. I found a user-defined
function RW_SOP_GetCustomerItemNumber but I don't know how to use it (what
parameters I need?) Does somebody know where I can find this information?
What I have found,
The customer items are added here...
"Veri Salvador" wrote:
> I want to add the Customer Item Number on my reports. I found a user-defined
> function RW_SOP_GetCustomerItemNumber but I don't know how to use it (what
> parameters I need?) Does somebody know where I can find th...Operation is not allowed when the object is closed
I seem to be getting this error from the client side of Headquarters quite
often, and I can't seem to find any solution online. The MessageBox also
says: "(Unhandled Error, state = '7')"
Seems to me this could possibly be a programming error, but I'm not sure.
Does anyone know of a solution to this problem? Or, does anyone know if this
is a problem that they haven't dealt with yet, or at least whether this is a
problem I'm supposed to deal with or they are supposed to deal with?
> I seem to be getting this error from t...How To Scramble The Variables in a module?
Does an Add-In exist that can do this?
Any ideas as of how it can be done?
Harlan Grove wrote:
> "TwIsTeR_0O0" <email@example.com> wrote...
>>Does an Add-In exist that can do this?
>>Any ideas as of how it can be done?
> Do you mean code obfuscation?
have values in cells f5 and h5.These values range from 1 to 1000,but ar
in bands, and there only allowed increments in each band.
Min max incr
1.00 2.00 0.01
2.02 3.00 0.02
3.05 4.00 0.05
4.10 6.00 0.10
6.20 10.00 0.20
10.50 20.00 0.50
21.00 30.00 1.00
32.00 50.00 2.00
55.00 100.00 5.00
110.00 1000.00 10.00
Thus allowed values are 1.01,1.02,-----,2.02,2.04-----,3.05,3.10,3.1
In cell c25 I have difference between f5 and h5.I need to put in cel
d25,the number of increments between f5 and h5.
Suppose f5 is 5.7 and h5 is 17. How many increments is this?
By hand,5.7 to 6 is 3 increments...Printing from the Store Operations Journal
I am trying to print from the store operation manager journal. When I go to
print I get a message indicating that:
"An error occured while trying to print to the specified printer. Please
make sure that you have a printer installed and that it is properly
configured before continuing."
I get this if I:
Click the Print button
Click the Page Setup button
Press Alt-P (per the help file)
I am running RMS 2.0 with SP2 currently installed. Earlier today I had SP3
installed. I uninstalled the program and reinstalled it and SP2.
I am a tech support person and do no...Number and Text issues
I have an .xls file that has a list of clients that I have filtered and
sorted. In column "A", there is a list of numbers, some that have preceeding
zeros and some that do not, but all of the numbers are of the same length.
I have created a macro in another .xlsm spreadsheet (driven by commandbutton
located on a userform) which allows the user to enter (via inputbox) a number
and it will search the .xls file and return to the userform the information
which is in the same row as the number entered by the client. This macro
takes all of the values in column "A&q...Money 2004 illegal operation error
Recently, about a week ago, whenever I close my Money 2004 program I get an
illegal operation error as follows; MSN has caused an invalid page fault in
Kernel32.dll at 0167:bff9db61. I have checked everywhere I can think of to
find the problem with no results. This only occurs when I close the program.
Sometimes when I click close on the error message it goes away and I can
continue normally, other times the error message just keeps popping right
back and I have to reboot to get rid of it.
I have tried uninstalling and reinstalling with no luck.
I am using Windows 98se and IE 6.0.
T...Selecting alternate rows
I have a large file (Excel XP) with about 300+names and related details. I
need to break it into 2 files but I need to select alternate rows for each
file. It may come out to every 3rd row to work into 3 files.
Is there a quick way to do this rather than tediously select each alternate
row, copy to the new file and delete from the old file?
Many thanks for your help.
Many thanks - I shall give it a go. If I have a problem, I'll get back to you.
"B. R.Ramachandran" wrote:
> You can break your data into two worksheets as follows:
>...Is there a number for Paid Outlook Support?
Is there a number for Paid Outlook Support?
My Problem is listed below. I have search on the newsgroups and forums
and have yet to get an answer, so now I guess I will pay. Please direct
me to the paid support phone number. If you think you can solve my
problem, that would be great too!
I am now using Outlook 2007, but this problem exists on Outlook 2003 as
I put all the correct settings in and then most times I can then read
and send email. The problem is that I keep getting this pop up box
Asking for the username and password for the server.