Help converting a file
I have a Mac Excel 1.x file that I would like to convert to Excel 2000. Any help is appreciated.
What is the best way to import all my data/info from Lotus organiser ver
5.02 to outlook 2000?
I don't have OL 2000 in front of me, but if you go to file | import/export,
import from another program or file, I think you'll see a Lotus Organizer
Charles Harvey wrote:
> What is the best way to import all my data/info from Lotus organiser
> 5.02 to outlook 2000?
In message <eBHW0UPdEHA.4092@TK2MSFTNGP10.phx.gbl>, "Lanwench [MVP -
Exchange]" <firstname.lastname@example.org&...Converting numbers into text
I am trying to convert numbers into text. I have tried formatting bu
it does not work. I am importing these excel data into SAS and SAS doe
not recognize the formatting. I think I need a quick way to add a
apostrophe in front of all my numbers, how?
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
I did try formatting the cells, but this does not really change th
number into text....
I want there to be an error in the cell, that is, I want excel to tel
me that...Expanding AVI video files
Can I expand the size of an AVI video in PP. I need the actual video to be
larger on the screen but when I expand it, it doesn't play properly....stops
and starts sporadically. I am running Vista and using 2007 PP.
I answered my own question. Effect options/movie settings/zoom to full screen.
> Can I expand the size of an AVI video in PP. I need the actual video to be
> larger on the screen but when I expand it, it doesn't play properly....stops
> and starts sporadically. I am running Vista and using 2007 PP.
&...Converting String to pairs.
hello i have a file that was pre generated for me. it contains many
colums and rows.
a certian colum constains a string of 6 digits, like 272829 and 359514
and so on. I need those split up into pairs, either by comma or
something else so i can do a find and replace.
so it could look like 27,28,29 and 35,95,14. Any suggestions for how i
can automate it. I regularaly get theses lists and they contain 1200+
rows. it takes me hours. thanks for your help.
If A1 contains 123456 then =LEFT(A1,2) & "," & MID(A1,3,2) & "," & RIGHT(A1,2)
-...Formula for Dates and CF Colour then convert to Text
Part 1 - Although I can do the CF on the cell, I am looking for a formula
based on the following:
1. Date entered is from Today up 7 Days - My CF will format cell to Green
2. Date entered is between 8 days and 14 days - CF will format Amber
3. Date entered is greater than 14 days (15?) - CF will format Red
My current formula's in CF based on:
Condition 1 - Formula is: =IF(D4<>"",D4>TODAY()-7)
Condition 2 - Formula is: =AND(D4<>"",D4>TODAY()-14)
Condition 3 - Formula is: =AND(D4<>"",D4>TODAY()-600)
-60...to encode or convert all my files properly.
I have office 2007 and 2003 products with full SP.
But I lost all my files and apps due to format my extra hard drive mistaken.
Could you let me know how to encode or convert all my files properly.
If you could, please let me know how to do?
In article <854FC33B-0830-4211-AB76-1018D0B17D8E@microsoft.com>, Eddy monroe
> I have office 2007 and 2003 products with full SP.
> But I lost all my files and apps due to format my extra hard drive mistaken.
> Could you let me know how to encode or convert all my files...Need to convert website to print catalogue. Help.
Client wants me to convert website into a print catalogue. I have the
latest version of Publisher. Is this the best software to use? Are there
any plug ins or add ons that might make the task easier/better? TIA
This won't be a very fun task using Microsoft Publisher
when importing a webpage to design a catalog for print.
While publisher can open the html pages, there will be
quite a bit of formatting loss. I am unaware of a program
that would do this any better than Publisher however.
Microsoft Publisher MVP
>-----Original ...convert decimal to inch & fraction
CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?
How small a fraction? To 1/64? 1/128?
Goto Format>Cells>Number tab>Fraction
From the Type drop down select either:
Up to 2 digits
Up to 3 digits
"davepatrob" <email@example.com> wrote in message
> CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?
...How do i convert entire document to Grayscale?
I have a publisher file (multiple pages) that is full of color text, clipart,
and other various things. How would i convert the entire thing at once to
grayscale? I dont want to have to click each indivitual item and change to
grayscale, i know how to do that. I also know how to change the whole
document from RGB to CMYK but I cant find any way to change it all to
grayscale. How do I do this?
File - Print - change your color in there to grayscale. No need to change
the individual items.
MVP Microsoft [Publisher]
How to ask a question
http://support.microsoft...Converting '97 to 2000, 2002, and/or 2003
Our office has Access '97. Our IT Department is upgrading
our Access to 2003, however, they state that 2003 is NOT
compatible with '97 and will NOT convert from '97. Per
our IT Dept., we have been advised to purchase an Access
2000 upgrade (which is no longer available), then a 2003
upgrade, so that when 2003 is installed, we will be able
to use our documents.
This does not seem right to me.
Does anyone know:
1. Is '97 convertible to 2003? if not,
2. Is '97 convertible to 2002? if not,
3. Is 2000 the only way to make this work?
97 will convert ...Converting text and listnum fields to multi-level lists
I have many documents with numbered paragraphs. They use a mixture of text,
listnum fields and multi-level lists to achieve the numbering.
How can I convert them all to multi-level lists using VBA?
This is a multi-part message in MIME format.
How can I best Stream audio in FrontPage
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">...convert column data into text
I need to convert a column of data (ie 1 2 3 4) into a csv text string (ie
1,2,3,4), are there any excel functions that will help...thanks for the help
You can use this macro, adjusting it for your needs.
ColumnLenght = WorksheetFunction.Count(Range("A1:A1000")) - 1
For x = 0 To ColumnLenght
csvresult = csvresult & "," & Range("A1").Offset(x, 0)
Range("B2") = csvresult
Simply paste it into a module in the Visual Basic Editor (VBE), pressing Alt
and F11 to get...Converting calendar events to tab-deliminated text
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Entourage 2004 does not allow exporting of calendar events to a text file or any kind of file readable by WORD or Excel. Is there any way to do this so I can create a database file to keep an archive of old calendar information? I don't want to rely just on the Entourage.rge file as the only archive.
On 12/11/09 12:35 PM, in article 59baecae.-1@webcrossing.JaKIaxP2ac0,
"Rodonator@officeformac.com" <Rodonator@officeformac.com> wrote:
> Entourage 2004 does not allo...convert formula to VBA
I need some help figuring out how to convert formulas that I have
working in an excel spreadsheet into VBA language in Excel. I have the
following three formulae that do just what I want. I go through all
kinds of hoops to open excel, write this formula in a cell, copy it
then write it to a new spreadsheet. would be much faster if i could
capture the value of all three formulae in VBA. Suggestions
What do I need to do to get each of those working. I think i...How do I preserve endnote links when converting a word doc to a pd
I saved a word document as a pdf document, but for some reason the formatting
allowing me to switch back and forth between the text and endnotes is not
working. Any tips for how to fix this?
...Quicken Convert #4
Downloaded Money05 trial.
Validated 10 MB quicken file.
Followed instructions in Money for conversion, hung-up computer, twice.
Reduced size of quicken file to 5 MB.
Now receive following error message:
Your Quicken file could not be converted.
Money could not convert your Quicken file. You might have run out of disk
space or system memory.
Try closing other programs and making sure the disk you are copying your
file to has enough space. Then try converting the file again.
--------------------------------------------------------...Asus P5E SupremeFX II Audio Card not recognized.
WARNING! SPECS AT THE BOTTOM!!!
Having trouble with Windows 7 32-bit, previously installed over a 64bit
version ( formatted partition & install ) because I wanted an english
version of Windows7. Just bought this new quad core computer, all happy
and everything about it, suddently, the sound card starts jamming, the
soundmax software to, after reboot, it could not detect any audio output
or something, leaving the volume control icon with a red X on it. So I
just decided what the hell since it was a french version, LET'S FORMAT!
Install went seamless, no issues, now arr...Audio Driver for BT in WinCE 6.0
I'm developing an audio driver which takes and sends the data from the
Bluetooth, HFP profile on Windows CE 6.0. I have taken the
driver(WM8746 codec,driver,using MCASP0) which was already present and
tweaked the code to configure the McASP that is dedicated for the
Bluetooth(McASP3). The McASP settings had the change of the clock
rate, pin dir & frame sync etc depending upon the master slave
settings of the McASP with the BT. BT is configured to be the slave in
my case. I've also configured the DMA settings, IRQ lines, and the
control and data registers for the ...Youtube Video Downloader KEYGEN 8046 [1/2]
...Convert back to publisher file
Hi, some time ago I created a website from Publisher 2003. I now have 2007
but have lost the original file. The website still exists but is there any
way to recapture the website back so I can edit it in publisher?
No easy way, but its possible. At the end of this article there is a method
described to rebuild your Publisher document: Common Sense Computing 101 aka
"Why in the world would you lose your publisher file?" :
In the future, please post web questions in the web group and we will try to
help you there: m...Converting xls format to csv format
I am trying to convert excel file (xls format), which
contains name and respective e-mailn ids, to csv format.
My goal is to convert this excel file to csv format so
that I can import all the e-mail ids in outlook using this
csv file. But when I try to save this excel file in csv
format it says "this feature is not supported in csv
format". But I get a csv file with which I can't import
those e-mail ids into address book. I don't know what is
the problem. I used to do this earlier. But now it is not
happening. Any help will be appreciated.
Thanks in advance,
Sri...how to reinstall conerxant audio device
Please help me out. I have Windows XP and cannot connect to the internet.
Everything else is working Office 7 etc....
thank you, Bobbie
> Please help me out. I have Windows XP and cannot connect to the internet.
> Everything else is working, Office 7, etc....
> Thank you, Bobbie
There's got to be more to the story.. the Subject line mentions :how to
reinstall Conexant audio device" yet you ask about connecting to the
internet. Did you lose both when you inserted a wireless, or other device?
On Mon, 22 Mar 2010 05:1...Converting numbers to "database" format
I want to convert numbers in excel to a format with a set amount of digits.
For example, 1 becomes 001, 12 becomes 012 etc.
I have created a special format using 000. This works until I want to work
with these numbers, for example by using CONCATENATE. So if I have 01 and
012 and want it to be 01012, it ends up as 112.
Any suggestion on how to preserve formatting?
with leading zeros i am assuming that these are "text"
numbers or numbers you are not going to do math with.
so your problem is the excel thing that they are numbers.
format them as text and make sure that t...