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
> ...Merging results from multi-selection fields
I've created a database with several fields containing multiple selections.
I'm hoping to display the results in 1 grouped field. Is this even possible?
I am an Access novice.
...Field Properties > LookUp
Please Help me to understand This>> I am sure this is working, But I need
I created a table with 4 fields;
CCID Auto number – index field,
CCName – Simple text,
CCNum – Numeric representation of CCName,
CCDescription – Simple Text description of the record.
Then I added the CCID field to another table as a Lookup field Named
CP_CCID, using the lookup Wizard which created this query>> SELECT
Tbl_CurrencyCode.CCID, Tbl_CurrencyCode.CCName, Tbl_CurrencyCode.CCNum,
Tbl_CurrencyCode.CCDescription FROM Tbl_CurrencyCode ORDER BY [CCName]; <<
and whe...Reports by date
I'm trying to get reports based on a user input date. I don't want all the
in the database just the entries from a certain date and newer.
Could someone please help?
...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...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 ...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...Limit on length of predecessor field issue
We are using MS Project 2003 (but this happens in 2007 also) and are using
the master/consolidated project function. We have inserted about 13 sub
projects and there are many (thousands) of links between the plans. Because
we're linking between plans, the predecessors & sucessors fields show the
path of the subproject being linked to/from. The plans reside on a shared
drive on a server and so the paths are long. Therefore after 2-3 links on
one task, the field doesn't show all of the predecessors (or sucessors), it
just inserts a "..." for each additiona...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 ...Sorting by number in a non-numeric field
Hi guys.. so question..
Say I have a row with example:
Desired result from a sort..
Now how do I get there? :P
kronik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31541
View this thread: http://www.excelforum.com/s...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...Field Privacy
I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the database can not see the number.
How can I do this?
It's going to be pretty much work if the SSN must be hidden from all other
Also you won't be able to use it as the primary key field. Note: using a SSN
as the PK is a bad idea anyway. What happens if you have an employee who is
not a US citizen and therefore doesn't have a SSN?
1. You'll need to implement user...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...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
...A reducing number by given dates
Hi all, basically what im trying to create is a spreadsheet showing ho
many payments i have left on an item i purchased. Now i pay $100 o
this item on every 2nd friday. So my question is, what is a formul
that will look at todays date and reconise that it is the second frida
when payment is due and reduce a given figure in a cell by $100. Fo
example, Total cost is $1000, payments = $100, payments are due o
07/10/05, 21/10/05, 04/11/05 etc So when the 07/10/05 arrives tota
cost will = $900, when 21/10/05 arrives total cost will = 800 etc
Obviously when the date is other than specified the tota...Passing dates to Sql Server 2005 stored procedure
I am trying to execute a SQL Stored procedure from Excel using VBA. Apart
from 2 string inputs, this proc also accepts two datetime imputs. When these
dates are passed via VBA, they are in the format "dd/mm/yyyy. However, the
SQL Server does not seem to accept dates passed in this format.
Applying different date formats in VBA does not help because eventually when
the dates shoot from Excel to SQL Server, they are in the format
"dd/mm/yyyy". I don't want to change the regional settings of the machine,
since it will only be a temporary solution.
This is...Change date format
I have tried to change a norweigian date format into swedish without luck.
Current date format 20.01.06
Would like to have 2006-01-20
If you enter 20 January 2006 in a cell and format it as dd.mm.yy you will see
If you format as yyyy-mm-dd you will see 2006-01-20
"Åsa I" wrote:
> I have tried to change a norweigian date format into swedish without luck.
> Any suggestions?
> Current date format 20.01.06
> Would like to have 2006-01-20
...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...Turning off feature that automatically creates dates?
When I type, for example, "4-44" (without the quotation marks) into a cell,
Excel automatically transforms the data into a date ("Apr-44").
How do I stop this?
Preformat the cells as Text (format|cells|Number tab)
then do the data entry
or prefix your entry with an apostrophe: '4-44
Jason Freeman wrote:
> When I type, for example, "4-44" (without the quotation marks) into a cell,
> Excel automatically transforms the data into a date ("Apr-44").
> How do I stop this?
-- ...Modified Date of a Worsheet
I am trying to display the last modified date of a worksheet in a workbook.
Googled it and came up with:
MyStamp = FileDateTime(ThisWorkbook.FullName)
The thing is that this applies to the WHOLE workbook and not the individual
sheet, which I don't need.
Tried to change the word Workbook in the VBA into Worksheet -- didn't work.
Can anybody help?
Excel doesn't save the change time of a sheet. If you want it you will have
to maintain it yourself, maybe just trap the Worksheet_Change event.