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 <email@example.com>,
"Charlie Brandon" <firstname.lastname@example.org> 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
> ...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" <email@example.com> 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...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!
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...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 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 ...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
...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...RMS license transfer question
I have a client who has decided to close their doors. I am not an MBS
partner, so I am not very familiar with the licensing. What I need to
determine is whether or not they can sell the license to another
organization. I know that some EULAs state that the license is not
transferrable, but I have not read the RMS EULA, so I'm hoping someone
This is a multi-part message in MIME format.
It's not transferable. The EULA i...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...Converting to PDF
I'm having trouble converting any Office document (mainly Word and
PowerPoint) into PDFs.
Clicking on the 'Convert to PDF' button tells me that I do not have a
PDF printer installed (even though I have a full version of Acrobat
Professional CS). The only way I can PDF these docs is to 'print' as a
PDF which gives me no output options and I end up with a PDF several
times the size of the original document.
Can anyone give me a pointer on how to get this problem fixed? I have
a PC that works fine (as in the 'Convert to PDF' button generates a
nice small PDF, not a g...Exchange 5.5: License problem stopping outgoing mail for new users. (urgent)
We have an Exchange 5.5 mailserver on 2000Server, and a
2003 server as main server, both are in the Active Dir
and the mailserver has been DCPromo:ed.
Problem: I activated the licensing service on the servers
a while ago, and since then the last added user, and any
user I add, cannot send mail externally. Internal mail
sends fine, but anything external comes back as "Message
delivery failed due to a limitation in the system".
(translated from Swedish)
When I look at the licenses for Exchange, at the 2003-
server, I see 116 CALs. We use about 50 (per seat).
When I look a...Converting a PageMaker file into Publisher
Does anyone know how to convert a PageMaker file into
Publisher? If so, I would greatly appreciate any help you
could offer. Thanks,
I don't have PageMaker but........ I take it that copy and paste is not what
you had in mind? (Do you have PageMaker on your system? What file formats
can you export to or save as?)
"Jesse" <email@example.com> wrote in message
> Does anyone know how to convert a PageMaker file into
> Publisher? If so, I would greatly appreciate any help you
> could offer. Thanks,
> Jes...Convert or Not?
Is there any reason or advantage to convert a BE/FE datatbase from 2000 to
2003? In the peer-to-peer network all machines are running XP and Office
Provided you keep the back-end (data) file in the "oldest" (A2000) version,
you should be able to link from front-ends in any (subsequent) version of
Access (e.g., A2003). It doesn't work the other way around (older versions
of Access can't read newer version data).
"DSmith" <Donna@NOTSPAMres-xraynews.com> wrote in message
news:%23S0lwIzdFHA.2548@TK2MSFTNG...convert trial version to previous office 7 purchased
I have just purchased a Toshiba Qosmio Laptop. It has a trial version of
Office 7 on it. I have tried to install a previously purchased key and cd
for Office Professional 20077 but it doesn't work.
Before installing your Retail Office 2007 Professional you need to uninstall the
Trial version and the Activation Assistant.
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"Deb" <Deb@discussions.microsoft.com> wrote in message
news:BA30...Converting SQL query to a procedure
Apologies but I need some help, I have a query that I use through my ASP
GetUserID = "Select myid= 'AA' From tbl_users Where AA= 'MMColParam1' Union
Select 'AB' From tbl_users Where AB= 'MMColParam1' Union Select 'AC' From
tbl_users Where AC= 'MMColParam1'"
GetUserID = Replace(GetUserID ,"MMColParam1", session("userid"))
This works fine so I tried to create a proc as:
Select myid = "'AA' From tbl_users Where AA= " +@Initials+ " Union Select
'AB' F...How to convert a dotted line to a solid line in a line graph
How do you convert a dotted line between two points to a solid line in a line
Click once to select the line, then click on a line segment to select just
that segment, then right click and choose Format Point, and select the
appropriate formatting in the dialog.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"Sharlz" <Sharlz@discussions.microsoft.com> wrote in message
> How do you convert a dotted line between two points to a soli...automatically converting data
when i make a change in one column i would like the material t
automatically change in another column.
for example, if something cost $1.25 per pound in my unit price colum
and in my total cost column it cost $3.75; if i change my unit pric
column to 1.50 how do i automatically change the price in my tota
Message posted from http://www.ExcelForum.com
in cell a3
where a1 contains 2 for 2 pounds
and a2 contains 1.25 which if you change to 1.50 will change a3.
"bob Tiburzi >" <<b...2008 Extent Volume
This afternoon i put some additional harddrive's into my server.
Before it was 2x72gb in Raid 1+0 (so 72 in windows)
I put 4 disk's of 72.
First i did a raid extent wich was succesfull, after there was 6x72gb in
After i try to extend my system partition from 72gb tot 205gb
Ther was a error "wrong parameter" ?
If i look into Disk Managment in upper box i see my C disk with 68.33gb.
And in the lower box i see Disk 0 with 205gb...
And in This computer i also see only 68.33gb.
Somebody can tell me what's happens? there was also no event log of i...Convert Hard-coded cell values to constants
If you have not guessed, I manage deer - lots of them in lots of
counties. For that reason, I'm trying to automate my population
models. In short, what I've developed is a simple accounting-style
population model that begins with a known population in 1981 and
attempts to mimic/model/simulate/track the population through time.
The population is composed of 6 age/sex classes. We'll use fawn does as
The name "accounting" comes from the fact that the model is like a
simple checking account, with simple deposits and withdrawals. As you
might imagine, w...Convert
Is it possible to convert a Money file created in the USA version to that of
the UK version?
Thanks in advance
The general way is QIF Export then Import. It's involved and has limitations
like loan accounts don't QIF. See http://www.bollar.org/msmoney/#Q1.
"Crispy" <firstname.lastname@example.org> wrote in message
> Is it possible to convert a Money file created in the USA version to that
> the UK version?
...MSO 2008 Mac SME Licensing Question
I'm about to redeem a copy of Microsoft Office 2008 Mac Special Media
Edition for $6.99
either MSO 2008 Mac SME 1 license or MSO 2008 Mac Home And Student
Edition 3 licenses.
Does anyone know if the SME single license permits the user to install
the software on their desktop Mac and also on ONE laptop Mac as other
Markets, not mandates and mob rule.
...Convert Word To Excel
I have scanned a document using OCR into Word 2007 with the RTF
format. I have three columns of data. I am trying to copy these
three columns to Excel 2007, but having a problem.
When I copy the data in Word, then paste to Excel, all the column data
goes to rows. If I copy the rows in Excel, and use the
paste/transpose command, the date is still in rows. How can I get the
columns in Word to stay as columns in Excel?
> I have scanned a document using OCR into Word 2007 with the RTF
> format. I have three columns of data. I am trying to copy these
> three columns to E...