Help Me Convert Fraction
I'm trying to customize a worksheet to read the fractions such as 14/16 as
7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
out there explain to me how to do this? I'm using Excel2000. Thanks!! CB
Take a look here:
In article <firstname.lastname@example.org>,
"Charlie Brandon" <email@example.com> wrote:
> I'm trying to customize a worksheet to read the fractions such as 14/16 as
> 7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
> ...How to Set Static Text value?
I use MFC VC++ 4.2.
I have a main window and a few child windows. If I click a button on the
main window, I must set the text of Static Text on the child windows.
I have tried to cast it to CWnd but it still don't work.
( ( CWnd* ) GetDlgItem( IDC_STATIC ) )->SetWindowText( "Insert Data" );
How to solve this?
You need to give the static control another ID (other than IDC_STATIC which
equates to -1) and then you will be able to set it. At that point you could
also assign a control and/or data variable to the control like you would any
The ...if value, then bold? any help?
I'm working on a spreadsheet to track mileage in a running club for
kids...and I'm trying to figure out if there is a way to make it so
that if their total mileage (E2:E20), then their names (A1:A20) could
be in bold...there's got to be a simple way, can anyone help?
You can do this with a conditional format applied to the names in column
A, depending on a formula relating to column E.
Unfortunately you don't say what specific condition you are looking for
(although I guess it is mileage > some number), and you don't say what
version of Excel you ha...Counting Values
On sheet 2 column A you are allowed to enter values from a drop down, what I
want to be able to do on sheet 1 is count the number of times each of these
Hope someone can help
Put your list in column A of Sheet1.
Then use a formula like this in B1:
and drag down.
> On sheet 2 column A you are allowed to enter values from a ...saving a converted lotus file
When I take a Lotus 123 file and save it as an Excel file
and then open the file in Excel, Excel opens the file
twice. In the title bar is says name.1 and name.2. Why
There are two windows open of the file.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"Pam" <firstname.lastname@example.org> wrote in message
> When I take a Lotus 123 file and save it as an Excel file
> and then open the file in Excel, Excel opens the...Comparing a value in EXCEL and XML files
want to know how to write a code in VB.NET for the following situation
> I have a field( Ex. Capital) in my XML file and that field results in a value(Ex. $5000)....now i have my Excel file with multiple worksheets in it....I want to write a code that can read a single field (Ex. Capital) in XML file and then take it's value (Ex.$5000).....After reading the $5000 it should search through my entire Excel file( In all Worksheets) and see if that Value exists ....If it exists then return as "Pass" if not "Fail".....I also hav 1 more condition but first i would like to...Does excel 2008 support color text in headers and footers?
Operating System: Mac OS X 10.6 (Snow Leopard)
I'm trying to apply text colors in a footer in excel 2008 and there doesn't seem to be an option to do so. I don't believe i've ever attempted this before, so it's possible that it's the expected behavior. Thanks, <br>
No, character formatting in all versions of Excel � Windows or Mac � has
always been very restrictive. I believe Excel 2007 offers more options, but
that is the only version which does.
On 1/13/10 2:48 ...convert concencated field to date
Concencate a number of imported fields into a date - Is is not possible to
import the fields as a number. Basically these are the date field from on on
I have tried a number of things
DOB: (TableName!Day & TbaleName!Month & TableName!Year)
DOB: Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))
DOB: #Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))#
DOB: ((TableName!Day) &"/"& Val(TbaleName!Month) &"/"& Val(TableName!Y...convert
Is it possible to convert an excel file into a word file?
> Is it possible to convert an excel file into a word file?
You can imbed an excel file into a word document, otherwise no not as
such. You could save the Excel file as text and then open in Word. Why
would you want to? Excel is not a word processor and Word is not a
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
to email me remove the obvious!
...Displaying a stored value
in a form I use the following working expression:
Dim strVersion As String
strVersion = 20080219
.... If DMax("[Version]", "[fileversion]") = strVersion Then
Me.Visible = False...
I'd like to display the strVersion content in a field so I do...
Obviously I'm doing some wrong because I get a Name? displayed error.
Where am I failing?
"Mike" <email@example.com> wrote in message
> in a form I use the following working expression:
> Dim ...field Null but not Null
Don't really know how to explain this, but here goes. Have a table
with fields [BLOCK], [NUMBER], and [ALPHA]. [ALPHA] can be null.
These are concantenated together to form Acct# (block & "-" & number &
alpha). Example, 9-152 is different account from 9-152G.
I append block billing charges to a temp table for review, and then
post (append) those charges to transaction table. But, here is
strange thing. When I run a totals query, sometimes there are two
records instead of one.
For example; acct# 9-152 might show as:
9-152 ...Graffic converters
Hi i have scanned in some photos using canon D1250u2f
scanner and have saved them as jpeg. When i am in
publisher and use the insert picture from file it tells
Publisher cannot convert this picture.This is because
either publisher does not recognise the format, or there
was an error loading the graffic converter.So on and so
on..... I have reloaded all graffics filters and am still
unable to insert this picture into publisher. Any ideas
whats going wrong? I have downloaded the latest drivers
for the scanner but do not want to spend hours downloading
all the office updates. Is th...convert HICON to HBITMAP
I am trying to convert an icon (already loaded by LoadImage), I have its HICON to a bitmap (HBITMAP), but I don't how. I CAN'T use GDI+( tried do with Bitmap class with the constructor and there was no problem), but I must use GDI.
Thanks to all.
HDC hdcScreen, hdcBitmap;
int x, y;
x = GetSystemMetrics(SM_CXICON);
y = GetSystemMetrics(SM_CYICON);
hdcScreen = ::GetDC( m_hWnd );
hdcBitmap = ::CreateCompatibleDC(hdcScreen);
hbmpBitmap = CreateCompatibleBitmap(hdcScreen, x, y);
Re...Backcolor value in hex
I want to get the hex value of a cell's backcolor, so I can replicate
the same color in Access. In VBA, I try to derive this by using
Hex(sheet.range(cell).interior.color). I get a hex value, but when I
try it in Access, it displays a different color. Am I grabbing the
correct property from the cell in Excel? Or, is there another way I can
derive the hex value?
Thanks in advance.
What version of Excel/Access are you using 2003 or 2007?
I'm believe you can set the color using HSL or RGB scales, which apply to
both Excel and Access (at least in 2003).
If this helps, pl...How do I convert cc's to a distribution list group?
I have received email as part of a 40 person cc and want to create my
own distribution list of those other cc's so I can originate messages to the
group (and not just use the 'reply all' key). Is there a way to move the
cc's from the header of an incoming email directly into a new distribution
group with out having to first make each of them a separate contact and then
move the contact into the distribution group?
Any help would be GREATLY appreciated.
Howard M. Rensin <firstname.lastname@example.org> wrote:
> I have received email as part ...Convert uppercase to lowercase
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?
Mervyn Thomas;593677 Wrote:
> Does anyone have a bit of code to convert a file of conatcts all in
> UPPERCASE to Lower Case?
For each cll in selection.cells
cll.value = lcase(cll.value)' either this line or the next
'cll.Value = Application.WorksheetFunction.Proper(cll.Value)
p45cal's Profile: ...How to set multiple filter values for a filter in the page fields
I have a filter on a time dimension I want to use time on the page
fields and still set the filter on different quarters.
When time is in a row or a column of the pivot table I can restrict
and set multiple filter values but when I move this time dimension to
the page field I loose the ability to set multiple filter values can
of you please suggest work arounds on how to accomplish setting
multiple filter values in the page fields of a pivot table.
Your help is highly appreciated.
There are some instructions here:
...How do I access auto text in Publisher
I am creating a newsletter and the temp;late includes text fields that show
the volume, issue and date. How do I access and change this data?
Click on the text box?
Are you having problems doing this? If you want to insert the date, click the date
text box, on the toolbar, insert, date and time. The volume and issue you will have
to do manually.
Mary Sauer MS MVP
"Joes" <Joes@discussions.microsoft.com> wrote in message
>I am c...Comment value from cell content
I would like to populate a comment with a value taken from a different
cell. Is there a simple way to reference a cell within a comment?
I am a fairly basic user with very limited knowledge of Visual Basic.
You can do what you want using the worksheet's Change event. Give this a
try... right-click the tab for the worksheet with the cell whose value you
want to incorporate in the comment (this is not the cell where the comment
will be placed; rather, the cell whose value you want to retrieve), click on
View Code from the popup menu that appears and copy/paste the following in
the cod...xmlTextWriter to Stream to xmldoc produces null stream?
I have a dataset from which I need to extract certain columns, format
them into xml and output to an xmldocument object.
From reading various posts on similar subjects, I have come up with
the following test code (using 2 constants, rather than my dataset
Public Sub test()
Dim doc As New XmlDocument
Dim xmlStream As Stream = New MemoryStream
Dim xmlWriter As New XmlTextWriter(xmlStream, Encoding.UTF8)
' Dim xmlWriter As New XmlTextWriter(Console.Out)
xmlWriter.Formatting = Formatting.Indented
xmlWriter.WriteStartElemen...Not able to find pdf converter option in Outlook meny
Have installed Adobe Acrobat standard ver. 8 but still not able to find the
PDF converter option in Outlook meny
If it causes a problem with Outlook, it will be disabled. You will have
to re-enable it in Add-ins.
> Have installed Adobe Acrobat standard ver. 8 but still not able to find the
> PDF converter option in Outlook meny
...sum a field value in all querys
How do i sum a value with another field (always the same one) in all my
Later, i would like to change that value to see the result in all querys.
How do i do that?
Please explain me best you can do cose i'm not an expert on access.
Tks in advance
What is the data type of the other field (always the same one)?
The value you wish to sum it with - what data type is it?
For example: if you had a query where one field was called rating and it was
a long integer, if you wanted to add the value 4 to this you could create a
calculated field in the que...graph displayed in ascending order of value?
I would like my graph to shows values in ascending order
on the x-axis. I know how to do this manually however as
the values change on a weekly basis I would like the
graph to autoimatically do this for.
You can do this on an XY chart. On the format axis menu, you can change
the scale to display the values in reverse order. If you are using
something besides an XY chart, please let us know.
"email@example.com" <firstname.lastname@example.org> wrote in
> I would like my graph to shows ...Convert DST to STD Time on the Fly?
For a database in the U.S. that sees a lot of analysis, I've
decided that a little reduncancy is a good thing.
Our field crews record DST when it is in effect, but our
analysts would usually like to use Standard Time. So I've
decided that it's better to have a field for each, and have
the form code do the conversion at data-entry time.
But I've taken several runs at coding this, and always get
to a point where I realize my approach isn't going to work.
I'm guessing others have preceded me.
Anyone care to throw something in here?
Instead of saving...converting to email
was wondering how you make a publisher file into an email without it becoming
an attatchment. I know it can be done !do i need to go thru another
> was wondering how you make a publisher file into an email without it
> becoming an attatchment. I know it can be done !do i need to go thru
> another programme?
Be aware that due to security settings
some of your recipients will receive your
newsletter as an attachment no matter
how you set it up and may not be able to
view the message in the context that was
intended. This is why...