Converting Claris Impact files (old Apple files) to M'soft Visio"
Hello I understand the the best way to access old Claris Impact files are to
convert using m'soft visio. I'm completely new to this application & will be
grateful if anyone can take me throughm the process of doing this. I've had
a look at the Versiontracker website on salvaging claris impact files but I
couldn't work out how it could help me! I really need some step by step help.
I've got Visio 2007 installed on my XP Pro computer Many thanks
Perhaps this link might help:
http://www.thefreelibrary.com/Orbital+Successfully+Completes+File+Converter+to+Allow+Cla...count between a date range
Hi, I want to be able to count between a date range and return the value yes.
I will show you the formula I currently have:
This gives a yes if the date is greater than the date in M2 minus 365. This
however cincludes all the dates beyond M2 which isnt what I want. I want the
dates upto M2. If that makes sense? Any help would be greatly appreciated
Jacob (MVP - Excel)
> Hi, I want to be able to count be...Converting Microsoft Office 2003 Trial into a full version
I have bought a Sony Vaio PCG-GRT360ZG notebook with installed Microsoft Office
2003. I registered Microsoft Office 2003 trial version. Now I am trying to
convert it into a full version. Unfortunately I am getting message that my
product key (from Certificate of Authenticity) is invalid. My trial version
expires in Jan 2005. What should I do ?
My product key from Certificate of Authenticity label is :
Thank you very much Peter.
...Help with Dates
I have a table with field name "ConnectionDate".
I want to create a form with ComboBox that will show the "ConnectionDate" as
month and year only.
The value the user will choose will be a criteria for a query.
?Format(Date,"mmyyyy") would return 112007
SELECT Format(ConnectionDate,"mmyyyy") AS ConnectDate FROM SomeTable
Dave Hargis, Microsoft Access MVP
> Hi all,
> I have a table with field name "ConnectionDate".
> I want to create a form with ComboBox tha...Converting Dates from YYMMDD to MMDDYYYY
I'm looking for a format function that will convert a date in the text
format of YYMMDD to text format of MMDDYYYY.
Any help would be GREATLY appreciated!
Thanks in advance!
You can't do it using a Format function, but try:
Function SwitchDateFormat(YYMMDD As String) As String
Dim strDay As String
Dim strMonth As String
Dim strYear As String
If Len(YYMMDD) = 6 Then
strYear = Left$(YYMMDD, 2)
strMonth = Mid$(YYMMDD, 3, 2)
strDay = Right$(YYMMDD, 2)
If strYear < "30" Then
strYear = "19" & strYear
strYear =...How can I prioritize tasks by number in Outlook 2007?
I am trying to create a custom priority for my tasks in Outlook 2007, but I'm
not able to edit the field that was created when I changed the settings to
include a custom priority. I'm trying to put a number into it, so that I can
sort my tasks in a certain category by number, but I'm not able to.
We aren't watching you and your explanation is missing details.
Where in Outlook are you trying to view the Tasks? There are 3 places to see
If in the Task Folder, what View are you in? If in Tasks folder you
probably need to turn on in-line editing.
Judy Gle...Calculate number of months
I have a field where I am trying to implement a calculation. I want it to
take the date in a cell and subtract it from today's date to show me the
total number of months between those two dates. So right now, it looks like
=(TODAY())-D3 and it returns 167 - the total number of days. How do I make
it show me months?
THANK YOU IN ADVANCE
"TxWebDesigner" <firstname.lastname@example.org> schreef in bericht
> I have a field where I am trying to implement a calculation...I have a problem with getting a total Sum of numbers (URGENT)
I'd really appreciate if someone could help me here.
I am using Microsoft Excel 2002 on a Microsoft Office XP system. I a
trying to develop a minor league baseball schedule, but am having som
I have attached a copy of my spreadsheet to give everyone some idea o
what I'm doing here.
I have where the fans list the "RUNS, HITS & ERRORS) of both teams an
for each game of the series. I then have it set up in the TOTA
WON/LOST column where if the T-Bones RUNS are more than the SALTDOG
runs, a "1" appears in the WON column. If the SALTDOGS have a highe
numbe...Automatic Data Entry Script OnChange Event for Date Field.
Sub: Automatic Data Entry Script OnChange Event for Date
has anyone assigned 'Today date'( new Date()) to a custom
date filed on the form - OnChange of a Picklist field, I
have the following code.
DatefiledName.value = new Date();
This assigns, currect date to the field, but then when I
save it does not like it. When I manually assign a date
it displays in the format mm/dd/yyyy, and saves
correctly, so I changed the script to:
d= new Date();
s = d.(getMonth() +1);
s += '/' + d.getDate();
s += '/' + d.getFullYear();
DatefiledName.value = s;
This also acc...Converting Adobe PageMaker 6.5 files
Does anyone know if you can convert Adobe PageMaker version 6.5 files so that
I can use MS Publisher 2007 to edit these files?
I suspect the only way is the copy/paste solution. If you don't have PageMaker,
maybe Adobe has help.
There is a forum here that might have a solution:
"SmithinSA" <SmithinSA@discussions.microsoft.com> wrote in message
> Does anyone know if you can ...number in system using arrivals and departures
Is there and easy way to figure out the total number of persons in a system if have access to the arrival and departure times. I have tried to use counts with if statements, but I keep getting the number 1. I know this is not correct. Is there any special macros or functions
you may provide some more details about your data. Could you post some
example rows (plain text - no attachments please) and describe your
> Is there and easy way to figure out the total number of persons in a
> system if have access...how would you calculate the number of hits to your website
can some one tell to me the answer of this question
On a website, how would you calculate the number of hits to your
...columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and
forumlas now look like =RC[-1]*R[-3]C
I was trying to make the R[-3]C static (using the $) but it errors.
In Excel Options uncheck "R1C1 Reference Style"
Gord Dibben MS Excel MVP
On Thu, 28 Oct 2010 20:25:30 -0400, Mike <email@example.com> wrote:
>I noticed my excel clumns have changed from letters to numbers and
>forumlas now look like =RC[-1]*R[-3]C
>I was trying to make the R[-3]C static (using the $) but it errors.
...A way to increase a number in a cell by using the + key
Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
Item 1 Item 2 Item 3
2 5 4
I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.
Any assistance would be appreciated.
That would require VBA
How far are you will...number changes to date ... how do I change
I am trying to do an "age" range:
Instead I get September 9, 2004
or October 19
I can't figure out how to change it.
Please help! Thank you!
Change the type to Text, and it should keep everything the way you want
it. If you don't specify a type, Excel takes a guess based on what you
Hope that helps.
Message posted from http://www.ExcelForum.com/
...reference number #2
Where does the information in the "reference number" field in the
transaction table come from? I see tranactions with reference numbers -
the first part of which appears to be the year, month and day - but I
can't figure out the second part. It is nothing that we have
intentionally entered while ringing out the customer. Pls help.
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
microsoft.p...Add numbers accross columns after stripping away text
I have the following data in a spreadsheet:
A1 B1 C1 D1 E1 F1
4.5f 6f 3.5f 3f 7.25f
I need to be able to add the numbers together to give me 24.25, i.e. strip
the fs away. The numbers will always be less than 10 and the there will only
ever be .25 or.5 or .75 after the number (I don't know whether that is
If anyone can show me how to do this I would be very grateful. I have been
messing around with MID and FIND to no avail and then started thinking that
SUMPRODUCT might have to get involved but it all got a bit m...Automatic date/time aquisition for graphs
Ok, I collect particle count data for a cleanroom which looks like th
When I use the following macro, what reference range is being employed that
makes certain decisions for the conversion? For example, when I have a date
of 1/12/46, this converts to January 12, 1946, not January 12, 2046; when I
have a date of 1/14/20, this converts to January 14, 2020, not January 14,
1920; when I have a date of 2/3//10 this converts to February 3, 2010 not
February 3, 1910??? Seems like this was only project so far into the future.
I haven't tried all numbers but once you reach that boundary it assigns the
20th century to any number there and above.
Su...Calculating Date Fields
I have a document that is filled with FormFields and users go from field to
field filling the fields for a final document. I have been reading up on
'calculated dates' but have not seen a scenario like this.
Three of my formfields are "Date1", "Date2" and "Date180." What I am trying
to figure out is how to evaluate/compare Date1 and Date2 to see which is the
earliest and then provide in Date180 the date 180 days from the earliest
date. (Unless the form is blank there will always be a Date1, but there may
not be a Date2 and if Date2 exist...Random numbers, Canadian Zip Code style #2
Honestly, I don't even know where to begin
Shocked's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1489
View this thread: http://www.excelforum.com/showthread.php?threadid=26523
...Converting incoming email to plain text
Is there any way I can configure Xch 5.5 to convert all received SMTP email
to plain text ? I can't find any option.
...converting long lists of prices
I work for a company that issues its customers with prices usin
excel... we have thousands of prices.. is there any way of covertin
all the indvidual prices and descriptions into a simple program or fil
so that customers can do a very quick search for a price!! The progra
or file needs to be small and easy for end user.
Thanking you in advance
Message posted from http://www.ExcelForum.com
In order to solve a problem you or to ask for help you probably
need to try to solve the problem yourself. How far did you get
what problems did you have. You must have some idea o...Convert "1" to "One" in Excel 2003?
How do I convert "1" to "One" in Excel 2003?
Use Laurent Longre's Morefunc.xll from
HTH. Best wishes Harald
"C2K" <C2K@discussions.microsoft.com> skrev i melding
> How do I convert "1" to "One" in Excel 2003?
C2K, have a look here
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always...Need to convert Julian Day to Gregorian date
I have a table that has a year field and day field. I only need to convert
the day field which is a Julian date to Gregorian. If possible in a query. If
not then in a module, but, I'm real rusty with access so please give explicit
instructions. I have found some codes but have not been able to make them
work with the table, I'm sure its me.
Thanks for any help you can provide me with.
There are loads of examples out there. The simplist one I could find that
SELECT DatePart("y",[TableName]![FieldName])+(Year(Now())-1900)*1000 AS