converting lotus 123 files to excel
How do I convet 123 files to excel ??
Until somebody who has actually done this answers:
Have you tried dragging your 123 file into an Excel window, and if Excel
opens it, saving it as an Excel document ("Save as type:" down at the bottom
of the "Save As" dialog)?
> How do I convet 123 files to excel ??
either save the file in Lotus 123 as Excel file or try a commercial
converter (e.g. www.dataviz.com)
"Pete" <Pete@discussions.microsoft.com> schrieb ...ATTN: Works wdb files to Excel 2003 converter query
I need to convert MS Works .wdb files - unknown version - to Excel 2003.
Do you have or know where I can download a free converter. It is only
needed for a couple of files.
AFAIK there isn't one, barring saving the Works files as version 2...very
old, or saving as an Excel file in Works
Microsoft MVP - Excel
"SeeAll" <email@example.com> wrote in message
> I need to convert MS Works..."Converted failed to open the file" error
I have a .net code that uses ExcelPackage to generate server-side
Excel 2007 spreadsheets. Basically, ExcelPackage is a wrapper aorund
the Open XML format.
My code is as follows
Dim newfilePath As String = "C:\Upload\Test.xlsx"
Using xlpackage As ExcelPackage = New ExcelPackage(newFile)
xlpackage.Workbook.Styles.Fonts(0).Bold = True
xlpackage.Workbook.Styles.Fonts(0).FontName = "Arial"
xlpackage.Workbook.Styles.Fonts(0).Size = Convert.ToString(9)
xlpackage.Workbook.Styles.Fonts(0).Color = ...how to convert number into colors?
I want to convert a matrix of results in decimal or real number into a
spectrum of colors (or grey scale if it's not possible) to make a "picture"
it's quiet urgent so a great thanks to who will success the challenge!
Here is one way
Private Const xlCIBlack As Long = 1
Private Const xlCIWhite As Long = 2
Private Const xlCIRed As Long = 3
Private Const xlCIBrightGreen As Long = 4
Private Const xlCIBlue As Long = 5
Private Const xlCIYellow As Long = 6
Private Const xlCIPink As Long = 7
Private Const xlCITurquoise As Long = 8
Private Const xlCIDarkRed As Long = 9
I have a customer (UK) whose base currency is Euro. How do I set region =
United Kingdom and currency = Euro at install.
Secondly, Is the Punt still recognised? I thought Eire went to the Euro in
2002 and therefor the currency list at installation is wrong.
You should be able to select a base currency when you first install Microsoft
CRM, which then becomes the 'default' currency for the installation of your
Organisation, presumably this would be the Euro in your situation.
Once this default currency for an Organisation has been chosen, i...How to Convert Char to Datetime
I am trying to use DATEDIFF here.
DATEDIFF(day, getdate(),CONVERT(varchar, tblMain.dtOpen, 101))
I got the following error:
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value."
It appears that I need to convert "tblMain.dtOpen" into datetime format to
calculate DATEDIFF, correct?
How can I convert Char to Datetime?
Thanks in advance.
What is the data type of the column dtOpen. If character data type, then what is the format?
You can try:
C...Converting date from an external source
I am having an issued with converting a date from external data source. the
data has the timestamp in the general date form mm/dd/yyyy 00:00:00. I want
to convert the date to mm/dd/yyyy format so when i run a query for a single
day it will return the data for that date, I can currently return the data
but i have to set the parameter in the mm/dd/yyyy 00:00:00 format, i want to
simply return the data by setting the parameter in the mm/dd/yyyy format
Don't confuse how data is stored with how it is presented. As long as you
import the date into a field defined as a Date data type, you...Excel 2002 converts 'S' to 0 when pasting from Clipboard
I came across the following problem:
I copied some tabular data from IBM Personal Communications into the
clipboard (yes, I am still a user of good old 3270 applications). Then
I pasted the data into Microsoft Excel 2002 and all cells containing a
'S' became a '0' (number zero).
Next I did some tests and found out that every single uppercase 'S'
that is transferred to Excel using copy/paste is translated to '0'.
This would not happen with other letters or with words containing an
Using 'Paste special' I can choose to insert my Clipboard a...Only one tool:Rip DVD and convert Video to PSP
This guide will show you How to rip DVD and convert Video to PSP with
Cucusoft PSP Video Converter Suite.( http://www.5idownload.
It include three parts:
Part One: How to rip DVD movie/video to PSP video format.
Part Two: How to convert AVI/MOV/WMV/ASF/Divx/Xvid/MPEG/RM to PSP video
Part Three: How to upload/transfer PSP files to your PlayStation Portable
Firstly Download( http://www.5idownload.com/download/PSPConvSuite_r461741.
exe ) and run Cucusoft PSP Video Converter Suite.( http://www.5idownload.
com/cu-psp-converter-suite....do u know about Excel tool that would convert figures into words
kindly let me know about a tool that converts figures into words in excel
How to Convert a Numeric Value into English Words
> kindly let me know about a tool that converts figures into words in excel
(remove nothere from the email address if mailing direct)
"Jagesh" <Jagesh@discussions.microsoft.com> wrote in message
Is there a converted for Excel XP 2002 SP 2 to read in a
spreadsheet created by an older version (Version 4 of
Works for Windows)... If so, how can I get it...
Please reply to my email address firstname.lastname@example.org
...convert PDF to text
Do yall have a trick to convert a PDF to text (without Adobe, the rich
person's application)? I use PrimoPDF to generate PDFs. Thanks!
You can try a copy and paste but the results are iffy. I use ScanSoft's PDF
Convert and have had varied levels of success.
MVP Microsoft [Publisher]
"Erika" <email@example.com> wrote in message
> Do yall have a trick to convert a PDF to text (without Adobe, the rich
> person's application)? I use PrimoPDF to generate PDFs. Thanks!
...convert .mdb to .mde
how to convert the extension .mdb to .mde and what's the use of this?
Message posted via AccessMonster.com
You do the conversion under Tools | Database Utilities.
The point is that it locks the design of forms, reports and modules so that
your users cannot change them.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"mroks via AccessMonster.com" <u35438@uwe> wrote in message
> how to convert the extension .mdb to .mde a...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Currency Formatting
I have a workbook with various worksheets in it. When I add an amount into a
and ENTER, the Dollar sign appears even though if I right click and select
FORMATT CELLS and select CURRENCY, NONE appears in the sected currency box.
If I open a new EXCEL sheet outside of that workbook and enter an amount
into a cell and ENTER, the Pound sign appears! Any suggestions?
If you right click, select Format Cells, you will also see Financial.
There's a dollar-sign too, so did you also check that?
"Janbri" <Janbri@discussions.microsoft.com> schreef in bericht
news:F5E1D...Converting .dbf files to .mdb
Can anyone tell me how in Office 03 small biz I can
convert a dbf file to mdb? I believe I did it a few years
ago but cannot rember how i did it back then.
In earlier versions you could link dbf-tabels directly - I'm not sure about
versions over 2000 jet. Maybe you have to install ODBC drivers for
FoxPro/VisualFox , p.e. from
(When sending e-mail, use address arvil<At>tarkon.ee)
"Chuck" <firstname.lastname@example.org> wrote in message
news:282301c4a45c$59773e70$a3...Convert VBA to ASP
I am considering changing my extensive VBA code database to ASP. Is this an
impossible task and should I just rewrite the whole thing? Is ASP the up and
coming language for database code? Is Microsoft going to be changing from
VBA to something else as its main code? I think I am out of my league on
this one and would appreciate some help.
No, I don't think ASP is "the up and coming language for database code".
ASP.Net has surplanted it already, and who knows how long it'll be before
Microsoft tells us ASP.Net wasn't the correct answer either?
Afraid I don'...How do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...Full Guide: How to Convert DVD to MP4, AVI, 3GP, iPod ......
DVD is the first choice for many people when they want to watch movies at home. It has high quality picture, different subtitles and audio tracks and most important, some of the DVD movies are more enjoyable than than the cinema one.
However, when we travel, when the disc is broken, when we want to backup the DVD movies, when we want to share the movies with friends, when we want to make usage of the movie, what should we do?
[b]Convert DVD[/b] to video video formats you need.
This guide aims to show you how to convert DVD to different video format both for windows/mac users.
[b]Part 1...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"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 othe...Converting from Money 99 up to 2007
Can somebody tell me how I can upgrade information from Money 99 up to Money
07 ? I tried to upgrade from 99 to 2003 however, the 2003 can't read the 99
version. A year ago I gave up and decided to keep a hard copy of all the
information I keep within my 99 version, but hopefully somebody smarter than
me can help me to recover this information
In microsoft.public.money, tico67 wrote:
>Can somebody tell me how I can upgrade information from Money 99 up to Money
>07 ? I tried to upgrade from 99 to 2003 however, the 2003 can't read the 99
>version. A year ago I gave u...how can i convert a publisher doc. into a word or excel doc.
how can i convert a publisher doc. into a word or excel doc.
You can't. Why do you think you'd want to? I can think of reasons why people
think they want it in Word, but *Excel*?
MVP Microsoft [Publisher]
"rbyrd01" <email@example.com> wrote in message
> how can i convert a publisher doc. into a word or excel doc.
How to save a Publisher publication as a Word document
Mary Sauer MSFT MVP
...Help Q: Entering 7 p time format, does not convert to 19:00
I am running excel 2002, and when I open a new spreadsheet, and enter a time
into a cell as 7 p it gets converted to 19:00
I have taken a spreadsheet file someone has given me, and reformatted it.
but whenever I enter a time like 7 p it shows up as 7 p
if I enter 7 pm it does get converted to 19:00
Is there a setting in the sheet itself somewhere to change this behavior ?
I have searched all over, and can find no reference to this.
Please help - TIA !
probably differences in the Windows regional settings for both machines
"ANONRW&q...converting from seconds to minutes
I have converted 4.52 to true seconds but how can I make it so the
seconds that seconds are converted back to true minutes
Reign's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29134
View this thread: http://www.excelforum.com/showthread.php?threadid=489264
Divide by 60 will get you decimal minutes, i.e. 4.5 is equivalent to
If you want Excel format times, divide by 60 by 60 by 24 and format the
cell as [m]:ss. This will show the time of 1:01:01,...How can I Convert Links into Values for only Visible Cells?
How can i convert links into values for only visible cells for selected
Push F5 then click Special, then "Visible cells" then ok. Now do copy -
paste special- values
*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
Thanks for your reply but
I got error "That command cannot be used on multiple selections."
Thing is that I have a series of rows, say from A1-A5 (visible & links) then
A6 (hide & formula). Now again from A8-A13(visible & links) a...