Formating assiciated to $ button
how can I change the formating associated to the $ button
in the toolbar
On some worksheet the button does nothing?
The $ icon applies the currency style to the selected cells.
One way to change what it does is to change the currency style.
Look under Format|Style...
Select Currency and change anything you want.
Note that these styles are workbook settings--each workbook saves its own
For that workbook (not worksheet??), maybe the currency style got deleted. You
can either create it manually (via format|style...)
or you could merge it from a workbook that has it t...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...conditional format of adjacent cell with different range and crite
Well I have to Conditional format a range of values of range of string
character. For Eg. Column A contains Weekdays, 5 Mondays,3 Tuesdays, 2
Wednesday, 7 Thursday, 2 Friday, 3 Saturday and 6 Sunday in Column A. With
having range of values from 30 to 100 in the adjacent cells of Column A.
Col A Col B
Saturd...Adventure Works licenses question
My company is using the Adventure Works Cycle MSDN license for testing
We also bought the full Suite Pro license with about 25 users to be put on
the prod environment.
My question is: is it possible to extend the number of users (from the
initial 15) in the Adventure Works Cycle test platform?
Only if your actual company name happens to be Adventure Works Cycle
The key is specific to the exact company name, capitalisation included
"Eric" <NOSPAMerich742001@yahoo.fr> wrote in message
> H...A question about thread,please help me
My program environment is .net2005.The partial code is shown as below:
void CfinalView::OnRButtonDblClk(UINT nFlags, CPoint point)
AfxBeginThread(RUNTIME_C...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Cell formatting when importing data
When I import data from a delimited file into Excel 2000, even though I have
pre-formatted a column as text, entries such as 12-5 and 1-4 -- which are not
dates display as dates. When I reapply the text formatting I get a number:
38691. How can I get 12-5 to display as is when I bring the data in?
Rename the file to *.txt and use the text import wizard, just click next
twice and in step 3 select text from column data format for this particular
column and click finish
"cjay" <email@example.com> wrote in message
news:90AAB750-BF9F...Display text with Unicode format (ex: Chinese) on controls written by VC6.0
We can write a project with Debug-Unicode mode and display text with Unicode
format? Ex: Chinese or Japanese
>We can write a project with Debug-Unicode mode and display text with Unicode
>format? Ex: Chinese or Japanese
With VC6 you can build a debug (or release) Unicode project that when
run on a proper Unicode platform (like XP) should be able to display
Chinese or Japanese texts (providing the font you're using has the
Tittle bar, menu, button can display text with Unicode format when i build a
debug Unicode project? We can use fo...Userform question
How do you select an item on a user form?
This is incorrect - txbFaceAmt.Select
But it would be great if this worked.
> How do you select an item on a user form?
> This is incorrect - txbFaceAmt.Select
> But it would be great if this worked.
Unfortunately that didn't work - when I put in
me.facecheck.setfocus - it gave an error
facecheck.setfocus - didn't do anything.
Sub txbFaceAmt_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Call FaceLimitCheck(txbFac...Graphing Question #4
I am trying to graph a set of data in 'XY (Scatter)' and am running
into a problem I've never seen before.
There are only seven values for 'X' - numbers 0 through 6.
'Y' is a set of percentages ranging from '0.00%' to '13.00%'
I have about 7,000 of these pairs.
When I graph this, I am not of seeing the six discreet bands of
percentages that I would expect. For some reason, instead of graphing
the 'X' value, it is graphing the order that the 'Y' value comes in
Instead of graphing:
4 ...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...Conditional Formatting II
Hello all. I received help from Frank yesterday regarding the above topic, colorizing cells based on different values. Where I am now running into a problem is transferring that same data into another sheet using a function to retrieve the data. More specifically, I have 12 sheets with data, one for each month. The 13th sheet compiles all the monthly data into a yearly calendar format extrapolating the data from the 12 monthly sheets. The problem is that the text (or values) copy over, but the bg color doesn't. Any advice
you're probably out of luck. Formulas ca...Why does VS not format an XML document?
I'm new to XML. I'm noticing that certain XML documents, when viewing XML
text, do not format in VS 2005. Instead, everything is rendered on one long
line. In Internet Explorer, the text formats fine. What do I need to do to
get VS to format XML text for me?
Randolph Neall wrote:
> I'm new to XML. I'm noticing that certain XML documents, when viewing XML
> text, do not format in VS 2005. Instead, everything is rendered on one long
> line. In Internet Explorer, the text formats fine. What do I need to do to
> get VS to format XML text for ...Questions on Bar Chart
I have 2 sheets, "Data Sheet" and "Chart Sheet". Data Sheet contains data
to create a bar chart in the Chart Sheet, including the data for bar chart
title. I have no problem creating the bar chart using the data in the Data
I am just wondering whether I can make the chart title dynamic, which means
whenever the value for chart title in the Data Sheet changes, the chart title
In addition, I want to insert an area on the bar chart for the Source
information. I also want the source information dynamic from the value from
the Data S...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...followup to my question
I just ran the debugger and did a
CWnd* wnd = GetOwner();
It showed me that the dialog is the owner of the toolbar. So why is the
dialog box not getting the message? How can i confirm whether or not it is
getting the message or than sitting in the message handler for the ON_NOTIFY
and running to cursor?
>How can i confirm whether or not it is getting the message
MVP VC++ FAQ: http://www.mvps.org/vcfaq
...Sumif and zero values question
I have a long list of product codes. Against each code is a number obtained
from a sumif calculation from another long list of the same codes. A large
number of these sumif results are zero. Is there a way of automatically
hiding the zero lines such that if one became greater than zero it would
automatically appear in the list?
In other words I would like to be able to automatically only list those
product codes where the sumif result was greater than zero.
(Hope that's clear!)
"Gordon" <GordonBP1@yahoo.invalid> wrote in message
news:elseLfUeEHA.596@TK2MSFTNGP1...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...CAsyncSocket Question ???
I am developing a live streaming application. Clients connect to the server
and server streams data (audio/video) to clients. There could be various
clients and i need to stream data in real time. Thus I need to develop a
Now the questions are coming :)
I am usinging CAsynsSocket. Main thread would have server socket listening
to some port.
Every time it accepts a new socket i would create a thread and assign the
client connected socket to the created socket.
My questions are:
1) Is there any better way of implementation.
2) Which thread will recieve the callbacks ...formatting excel
I am trying to make score sheets for a dart league I play in, and I would
like to find out if I can rotate the entire setup of excel so that the rows
are parallel with the long side of the page. Is this possible?
I think you want Copy, Paste special, Transpose.
"pikeylover" <firstname.lastname@example.org> wrote in message
>I am trying to make score sheets for a dart league I play in, and I would
> like to find out if I can rotate the entire setup of excel so that the
> are parallel...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...re re re ????
I use Office 2002 with Windows 2000 and I would like to use the format
(500.00) when it is negative instead of the minus sign when writing numbers
I do not have that option in the format cell, how come?
My friend is using the same Office 2002 with Windows 2000 and she does have
the brakets in her format.
We both have the same Service Pack for Office and Windows.
she can simply enter the same format as custom format. she probably has
different regional settings
> I use Office ...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...