Over 1 million tech questions and answers.

Solved: Converting .wb3 files to Excel

Q: Solved: Converting .wb3 files to Excel

Hello

I have an old Quattro Pro file which I would like to access but do not have Quattro Pro installed any longer. I believe it may be possible to open in Excel. When I opened Excel and click on Open, File Types, I tried Quattro Pro/DOS types but that (and any other trial I've had) returns a warning message ".wb3: file format is not valid". The file had been on a 3.5" floppy and maybe (hopefully not) the floppy is unreadable.

My OS is Windows XP and I have Excel 2003.

Thanks for your time

Greta

RELEVANCY SCORE 200
Preferred Solution: Solved: Converting .wb3 files to Excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Converting .wb3 files to Excel

Welcome to the board.

Try this?

Read other 2 answers
RELEVANCY SCORE 65.2

Hi there bright people,

I am having trouble converting a LOC file type into EXCEL.

I have tried every type of special copy and paste and tried different formatting, but everytime i get the same result. That being cells that will only show (example) 1.440000E+62, or somthing similar. I will then expand the cell to cope with the length of the text but still the same result

I can however open the LOC file in Notepad or wordpad and can view the document there, but I need to be able to manipulate the data in Excel to be able to run a Macro over it.

Any help from an Excel Guru would be great.

Yours
Hicbart
 

A:Converting LOC files into Excel

Have you tried "Importing" the data straight in to Excel?
Alternatively if you save the file in Wordpad as a comma delimited file, Excel can then open it directly.
 

Read other 2 answers
RELEVANCY SCORE 65.2

Good Day !

I receive via email 2 reports daily from a POS system for restaurantscalled ALOHA.

The first salesreport from ALOHA is sent in "sls.rtf" format...the second report is sent in " pay.rtf" format. My Santa Clause wish is to export these figures into excel...or ultimately to quickboooks.
The rep for the POS system said it was not possible. Is he correct?
 

A:Help converting sls.rtf files to excel

smgisland, Santa Clause has come early. You can import rtf files in to Excel.
Whether you can make sense of the data afterwards is another thing though, it may take some data manipulation.
To import a file go to Main Menu>Data>Import External Data>Import Data
to browse to your file change the File Types to either "all files" or "text fies".
 

Read other 3 answers
RELEVANCY SCORE 64.4

I would like to know how to convert old files .wpd/.wpl to Excel or Word. O/S is XP. These files have been saved to a floppy and the old computer has died so cannot access files to resave.
I've tried changing the extension to txt, doc. dbf, xls etc. and opening up in several different applications but receive only non-text information (squares etc.).
Can someone help with this dinosaur file?
Thank you.
 

A:Converting wpd/wpl files to excel or word

what are they from word perfect - you may be able to open with word - in word - open - change the filetype to the ones you have
 

Read other 2 answers
RELEVANCY SCORE 63.6

Dear All,

I need to convert a set of 12 excel sheets in a particular folder into txt files which need to save at other location(another folder).

Please help me out in this regard

Shiva

A:Macros Code for Converting set of Excel files to Txt

Try this: Convert An Excel Spreadsheet To A Tab Delimited Text File - How-To Geek

Read other 4 answers
RELEVANCY SCORE 59.2

howd'y

I'm just wondering how to convert this spread sheet file (.wks) to excel 2007..

i know thats a lot of years in between the two programs but there must be a way to convert it.. or is there?

so i do need to open and re use the spread sheet but i don't know how i got that program in the first place.. so yer.

ive tried to convert it using excel 07' and was a fail. only came up with all differnt characters.

thanks for reading.
 

A:Solved: converting spreadsheet (.wks) to excel 07

Is this of help ??? http://forums.techguy.org/business-applications/779694-solved-works-vs-excel-formats.html
 

Read other 3 answers
RELEVANCY SCORE 57.6

Hello,

I have tried seaching for this information, but I can't find it anywhere.
What I would like to know is, do function words in Excel convert automatically if sent to someone with Excel in another language.
For example:

I am user English version of Excel. In my spreadsheet I use "COUNT" funtion. If I then send this document to someone who has the French version of Excel does "COUNT" then become "COMPTE" (which is the French equivalent).

Thanks in advance
 

A:Solved: Converting excel functions from English to French

Read other 6 answers
RELEVANCY SCORE 57.2

I am trying to extract a date from a data cell within an Excel 2003 workbook.

The cell contains the data, "October 10, 2011 11:11:11 PM GMT-04:00" but I want only the date information and for it to convert to MM/DD/YYYY format. Basically, taking that cell and turning it into 10/10/2011.

I have about 500 entries with similar data and I am looking for the easiest way to extract the dates from the text. Mind you, the length of the Months (i.e., January vs. September), Date (i.e., 1 vs 11), and even time vary (1:00 vs 11:11).

Any help would be greatly appreciated!

Found the answer I was looking for:

Assuming the first cell is A1,

=TEXT(LEFT(A1,FIND(",",A1)+5), "mm/dd/yyy")

Copy down, then copy the column and paste values.

You can also use

=DATEVALUE(LEFT(A1,FIND(",", A1)+5))

then format the cell as mm/dd/yyy, then copy down.
 

Read other answers
RELEVANCY SCORE 57.2

Hi,

Here is my problem. I'm making a countdown timer in Excel. The process is working fine, but my problem is when I call my Sub to set the time at which I want the countdown to end, I receive the following error:
-------------------
Run-time error '6':

Overflow
-------------------

Here is my code:

Dim TimerEnd as Date
Dim WorldPop as Integer 'This value is picked from my Excel worksheet

TimerEnd = Now() + ((1500 - (3 * WorldPop / 8)) / (60 * 60 * 24))

Note: WorldPop was tested and the value from the cell is really loaded because I was able to modify another cell value by assigning WorldPop value to it.
---------------------------------------------------------------------

Basically, I store in TimerEnd the time at which I want the countdown to reach 0 (obtained by doing TimerEnd - Now() )

The 1st part of the expression:
(1500 - (3 * WorldPop / 8)) determines in how many seconds the timer should end

The 2nd part of the expression:
/ (60 * 60 * 24) divides the 1st expression to obtain the seconds in decimal value which is added to Now() to get the end time.

What I don't understand is that when I type this expression in a cell of my worksheet that have been formated as date:

=NOW()+(1500-(3*850/8))/(60*60*24)
Note: 850 is just a random number which I tested the result. It can be any number ranging from 0 to 2000

It gives me a valid time in the cell.

What am I doing wrong so that in the code of my subroutine it gives me Overflow?

Is there ... Read more

A:Solved: Excel: Overflow error when converting decimal to date

I found the problem.

The following expression was too long:
TimerEnd = Now() + ((1500 - (3 * WorldPop / 8)) / (60 * 60 * 24))

I simplified it to:
TimerEnd = Now() + ((1500 - (3 * WorldPop / 8)) / 86400)

and it resolved my problem.
 

Read other 1 answers
RELEVANCY SCORE 55.2

My sky+ box packed up so i decided to take out the HDD and connect it to my pc so as to "extract" the videos on it.
With some internet searching i came across a tutorial on how to do it.
I downloaded +Extract and ran the program and converted all the files to .SRT files, then it said to convert the .SRT files to MPEG and then to AVI but the program won`t convert the files to MPEG, it keeps just giving me a text file, then i read somewhere that said .SRT files are text files.
SO now i`m totally confused.
Is there a way of taking video files from the HDD from a SKY+ Box and convert them into a watchable file, don`t have to burn them to DVD, AVI format will suffice?
Thanks in advance.
 

A:Solved: Converting .srt files

Read other 10 answers
RELEVANCY SCORE 55.2

Is there any way to convert WMA files to Mp3 ?
 

A:Solved: Converting WMA files to Mp3...

Lots of ways, take a look here: http://www.mp3-converter.com/mp3_converter_freeware.htm
 

Read other 1 answers
RELEVANCY SCORE 55.2

My business partner emailed me some files but they're .wps and the computer I'm working on won't let me read them.... is there anyway I can convert them so they'll open with Microsoft Word????? HELP!!!
 

A:Solved: converting .wps files

Those are Microsoft Works files, altogether a different format and Word should open them, although it may not be associated with that file type.
Open Word, go to Open. Browse to where the Works files are located. Change the file type (at the bottom of the browse window) by clicking on the down arrow. If you scroll down far enough, you should find Works (possibly several versions) listed. Select one of these and the file should open up for you.
You might ask your business partner to save any files in the future as .RTF (Rich Text Format) files. A bit of formatting may be lost, but that type is one both programs can use. Works cannot do a thing with Word documents.
 

Read other 1 answers
RELEVANCY SCORE 55.2

I have a number of scanned reference letters from my business that I previously scanned with a Visioneer scanner in Paperport 7.0. As Visioneer is so proprietary, and I am not using it anymore, I would like to convert all my Paperport files to anything else with which I could view and print these files within Windows Vista. I now use an HP Deskjet F4280 for all my scanning. Any help will be greatly appreciated. Thank you.
 

A:Solved: Converting .max files

Check out the following, http://www.ehow.com/how_6030039_do-max-file-pdf-file_.html
If you no longer have Paperport installed there is a converter to download and install.

I have NOT used this, so I can not help any further.
 

Read other 2 answers
RELEVANCY SCORE 55.2

Anyone out there know how or if there is a way to convert .ram sound files to .mp3? Any help will be appreciated.

E.
 

A:(Solved) Converting .ram files to .mp3

Read other 9 answers
RELEVANCY SCORE 55.2

Hello

This is a two part question

I like to give a bit of a background to this issue before i ask for help.

I am a personal care worker for a retired school principal who had contracted MS, he has very limited physical abilities but still has alot of interests including computers.

Question one in a broad scope is can i use this service ( techguy ) to come for help as i am the person that will be doing the physical work on the computer. He is getting a voice operated system in six weeks so he will be more involved.

Question two is more specific, i need to convert music files from MP3 to WAV and vise versa, i want to know if there is a way to do this without downloading any programs, he lives on a farm and the only internet service available is dial up and downloads take forever , i know of a program ( Audacity ) is thats the only option.

Thank you

Dan
 

A:Solved: Converting files

Read other 15 answers
RELEVANCY SCORE 54.8

Hi there

I was wondering if there was a relatively quick and simple way to convert and then burn avi files onto a dvd disk that can be played on a standard dvd player.
I am getting a bit confused re. recoding etc. Would it be better to use the burning software I have i.e. nero to recode then burn the files or is it quicker to convert the avi's to another format first then allow nero to burn them onto the disk?

Thanks in afvance!
 

A:Solved: Converting AVI files to burn to DVD

If DVDFlick (www.dvdflick.net) recognizes the filetype it can make a fully functioning DVD for you, no fuss, once you've set up the initial settings. Try the beta if you want to add menus (otherwise it will only chapter by set time intervals).

Otherwise it doesn't matter much either way, its going to take about the same time to convert the video to MPEG-2 DVD format and about the same time to burn them because both processes are hardware speed dependent (conversion most likely on the speed of the processor and burning on the speed of the optic drive or speed that the media can handle being burned at).

The step alluded to in your post about converting avi to another format and then burning is only if the format is the DVD-compatible MPEG-2 format. An intermediate format would indeed take much longer then since the resulting format would have to be converted to NTSC or PAL MPEG-2 to be DVD-compatible.
 

Read other 2 answers
RELEVANCY SCORE 54.8

I created a Word file that contains my business cards. (I also have the same file converted to PDF.) I'd like to try a new on-demand printing service that requires a Photoshop file (EPS.) I do not have Photoshop and I was wondering whether there was a way to convert the existing PDF file to EPS. Thank you for any leads...
 

A:Solved: converting Adobe PDF files to EPS

Read other 7 answers
RELEVANCY SCORE 54.8

Is there a program I can use to convert .cda music files to mp3?
 

A:Solved: Converting .cda music files

You cannot, a CDA file is an audio track shortcut file. You need to rip the audio off the physical disc. There are a huge amount of cd ripping programs, including iTunes and Windows Media Player.

http://en.wikipedia.org/wiki/CD_Audio_track_shortcut
 

Read other 2 answers
RELEVANCY SCORE 54.8

How do I convert a .wav file to an mp3 ?
 

A:Solved: Converting .wav files to mp3 format

Read other 8 answers
RELEVANCY SCORE 54.4

I run a weekly excel 2007 macro that converts a spreadsheet to a Word document, but it stops after row 29 of data. Any spreadsheet with 29 rows or less works fine. If I have 34 rows of data, the macro hangs. See below for script. Any help would be appreciated.

Public Sub AddControls(WrdApp As Word.Application, CurRow As Integer)
Dim OptChecked As Boolean
Dim GrpName As String
GrpName = "Grp" & CurRow
'Calculate the colors based on the cell information.
CurRange = "F" & CurRow & ".." & "F" & CurRow
Range(CurRange).Select

If InStr(1, UCase(ActiveCell.Text), "X SRM") > 0 Then 'SRM
OptChecked = True
Else
OptChecked = False
End If

SetCellBG WrdApp, True
WrdApp.Selection.TypeText Text:="Governance:" & vbCrLf

Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
With RadioObj.OLEFormat.Object
.GroupName = GrpName
.Caption = "SRM"
.Font.Name = "Arial"
.Font.Size = 8
.Value = OptChecked
End With

If InStr(1, UCase(ActiveCell.Text), "X PPO") > 0 Then ' PPO
OptChecked = True
Else
OptChecked = False
End If

WrdApp.Selection.Collapse Direction:=wdCollapseEnd
WrdApp.Selection.TypeParagraph

Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
With RadioObj.OLEFormat.Object
.GroupName = GrpName
.Caption = "PPO"
.Font.Name = "Arial"
.Font.Size = 8
.Value = O... Read more

A:Excel Macro - converting excel to word doc - stops after row 29

Read other 13 answers
RELEVANCY SCORE 54

Hi,

I was wondering if anyone could help me out.
I've written a batch file for a client to help him to change his IP settings - he uses his laptop on 2 seperate networks, but would like to use only 1 network connection (against my recomendation ... i suggested creating a seperate network connection for each).
His home network uses DHCP, while his work network uses static IP settings.

The batch file i've written works fine, but it doesn't look very professional ... I'd prefer it if I could write it in Visual Basic (at least it'll look half decent then).

I've read other posts, and all I can find is one posted by aaronmcgowan, which was rightly closed (as it seemed he wanted to bypass school/work proxy settings).
My batch file has no illegal/inappropriate purpose, it's just to assist in my clients daily network usage (and should hopefully cut down on the number of support calls i get)

What I'd like to know is, is it possible to convert a .BAT file into Visual Basic?

Thanks,

Max
 

A:Solved: Converting .BAT files into Visual Basic

How about if you just tell him to use this.
http://www.netsetman.com/
 

Read other 2 answers
RELEVANCY SCORE 54

hi guys,lately i have been converting my hundreds of cd music disks as mp3`s to cut down on space,i have been using "record now v.7" to convert them,but as there is no option to name the tracks,it has taken me days & days to retype track numbers as i have been putting at least 500 tracks of different artists on one dvd disk,is there possibly another program that will do eg. 20 of the same number tracks,that would make my life a little easier at the moment !!!!!! crossing my fingers.....
 

A:Solved: converting cd music disks to mp3 files

Windows Media Player?
If you allow it, it will find info about the CD from the net and name the files.

There's also dBpoweramp, Audiograbber, CDex, Exact Audio Copy, Winamp pro ... the list goes on.
 

Read other 3 answers
RELEVANCY SCORE 54

I have some files that are saved from outlook in dbx format. I want to try and convert these files into pdf. Is there any programs that will convert that are free. The programs I am finding all give you a demo version, but they are so limited. Outlook won't allow me to import the files back in so I can forward the emails onto another program. What are my options here. Thanks.
 

Read other answers
RELEVANCY SCORE 54

I convert a lot of web page articles to PDF files using Acrobat Pro 6.0. Occasionally the Acrobat icon in my toolbar won't even light up. If I save the page as a MHTML file and open it, the Acrobat icon is active but won't complete the conversion. Does anyone know if some newspaper pages are protected from copying with Acrobat? This happened to me this morning when I tried to convert a WSJ article (I'm a subscriber) to a PDF file.
 

A:Solved: Problem converting web pages to PDF files

Instead of using the icon, have you tried to actually print, from the file menu, and choose to print to the .pdf printer?
 

Read other 3 answers
RELEVANCY SCORE 54

I have a number of voice memos recorded in my iPhone and would like to convert them to text files. Can this be done?
 

A:Solved: Converting voice files to text

I don't know about any iPhone software, but there are plenty of computer Speech to Type programs out there.

Off the top of my head,
-Dragon Naturaly Speaking.
-TalkIt TypeIt.
 

Read other 3 answers
RELEVANCY SCORE 54

I was playing my game, Super Smash Bros. Brawl, and saved a replay that I would like to upload to Youtube. Before doing this, however, I have to convert the .bin file on my SD card to a video format (any video format is fine).

I've tried using Google, and many results tell me I should use vcdgear or a combination of Daemon Tools and other assorted programs, but I fear most of these results are also in reference to movie files (so they include .cue files, which are not present in this case--therefore, these results are of no help to me).

Other results have stated that simply changing the extension from .bin to .avi would be enough to be able to upload it, but the extension is not present on these filenames and I don't know how else to change them.

I'm using Windows XP Professional. Thanks in advance for any help.

Edit: I just realized this might be the wrong place for this thread...I can't seem to delete it, so if this is the wrong place for it, I apologize.

Edit 2: Never mind. Apparently Brawl replay data is basic commands and not a video file so it cannot be converted.
 

Read other answers
RELEVANCY SCORE 53.6

I am trying to use the Copy and Convert module along with Tivo's Desktop App to convert video for my Ipod Touch. Can open Copy and Convert and then add recorded TV show by clicking on the movies tab and navigating to the C:\Users\Home\Documents\My TiVo Recordings folder. I then click OK and the selected video appears in the source box. I choose Ipod Touch as the Output and Save file to Itunes. A message pops up as follows: There was a problem creating a file. c:Users\Home\Documents\My TiVo Recordings for Portables\MPEG-4\the forgotten\MY Movies\-The system cannot find the path specified. This is for an old video that has long since disappeared. Can you assist in getting around this problem so I can convert videos to my Ipod. I have reinstalled the TiVo desktop app which did not help. I had been able to use the two programs previously.

Using Creator 2010 SP2 with Windows 7 Home Premium 64bit. Dell Studio 540, 8GB RAM, ATI Video Card 512MB, Pentium Dual Core Processor E5400 @2.7Ghz
Thanks
Steve Rehmann
 

A:Solved: Converting .TiVo files to Ipod Usage

Read other 10 answers
RELEVANCY SCORE 53.6

I have a folder full of files that I want to convert from Word 07-10 (*.docx) format to Word 97-03 (*.doc) format so I can copy them to an old PDA and view them from there. In the absence of finding a good converter (there aren't a lot of people wanting to go backwards), I have been trying to use a Macro. I found some code on a previous post in this forum and tried to modify it using some code I recorded in Word, but it keeps giving me errors or otherwise does nothing at all. Any suggestions or corrections would he great. I think only the first two peramaters under "SaveAs2" are necessary for my purposes (FileName & FileFormat) but I let the others for the recording in in case Word needed them.

Sub SaveAs03()

vDirectory = "C:\Documents and Settings\<username>\Desktop\FolderA\"

vFile = Dir(vDirectory & "\" & "*.*")

Do While vFile <> ""

Documents.Open FileName:=vDirectory & "\" & vFile

ChangeFileOpenDirectory "C:\Documents and Settings\<username>\Documents\FolderB\"

ActiveDocument.SaveAs2 FileName:=vFile, FileFormat:=wdFormatDocument _
, LockComments:=False, Password:="", AddToRecentFiles:=True, _
WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
False, CompatibilityMode:=0

ActiveWindow.Close

vFile = Dir

Loop

End SubClick to expand...
... Read more

A:Solved: Converting Files to Word 2003 with a Macro

You are trying to save with the name something.docx

Try stripping the Docx and adding Doc

vsavename = Left$(vfile, Len(vfile) - 4) & "Doc"

Sub SaveAs03()
'my folders are on the desktop
vDirectory = Environ("USERPROFILE") & "\Desktop\FolderA\"
vfile = Dir(vDirectory & "\" & "*.*")
Do While vfile <> ""
'MsgBox vfile
Documents.Open FileName:=vDirectory & "\" & vfile
ChangeFileOpenDirectory Environ("USERPROFILE") & "\Desktop\FolderB\"
vsavename = Left$(vfile, Len(vfile) - 4) & "Doc"
ActiveDocument.SaveAs2 FileName:=vsavename, FileFormat:=wdDocument
ActiveWindow.Close
vfile = Dir
Loop
End Sub
 

Read other 2 answers
RELEVANCY SCORE 52.8

I need to have editable text, preferably as WORD .doc to create files to be sent to another person. Is there some sort of conversion process for some wordpad text I now have?
 

A:Solved: converting text files in Win XP from wordpad to a WORD document

Simply open them in Word and save them as Word files. Nearly everyone can open WordPad files though.
 

Read other 1 answers
RELEVANCY SCORE 52

A month ago I downloaded Excel 2007's Trial Version...all OK. I previously had Excel 2003 installed. I purchased an upgrade of Excel 2007, placed the disk in the C drive and followed the installation instructions. (I should have used the conversion route, but I didn't.) It appeared the upgrade installation was successful, but the "Trial Version" notation still appears on the top line of the screen. I then went the conversion route, entered the Product Key again, and received the message something like "Product Key already used." How do I make the Product Key work...or how do I obtain a new Product Key? What to do, please? Thanks. Kiki2
 

A:Solved: Converting from Excel 2007's "Trial Version"

Have you tried to uninstall the trial version of Excel and then just install the upgrade copy you have?
 

Read other 2 answers
RELEVANCY SCORE 51.2

I have 2 excel files. (Excel1.xls and Excel2.xls)

Excel1.xls has the following columns:

Client name | ID| FACS

Excel2.xls has the follwoing columns:

Client name | ID| FACS

I would like to connect this two excel files together and get the FACS number from the second excel file (excel2.xls and insert it in the excel1.xls under the FACS column) But it needs to match the client so all the FACS numbers go to the right client. The client list may be mixed and its not in order.

Can anyone help me please?
Id appreciate it
Thank you
 

A:Solved: Excel Help - Merging excel files

Read other 7 answers
RELEVANCY SCORE 49.6

Hi,

I'm trying to convert an excel spreadsheet to a PDF file. While it can do so, I have a graph in the excel document, along with an arrow pointing to a value on the Y Axis. When I convert the spreadsheet, however, the arrow gets moved up half an inch or so, which makes the graph and arrow inaccurate.

Please help!

Thanks,

JFresh
 

A:Converting Excel doc to PDF

Read other 7 answers
RELEVANCY SCORE 49.6

I have Adobe Pro 7 with Office 03.
I'm able to convert Excel to pdf via printing options. However, I can't seem to get multiple tabs to convert to one pdf document.
I don't want to select entire workbook because that will convert all tabs.
How do you select it so you only convert some tabs to pdf?
 

A:converting excel to pdf

Read other 6 answers
RELEVANCY SCORE 49.2

My boss just asked me to convert a publisher 2003 file to an excel 2003 so it can be used in another store location. Is that posible and how?
HELP!
 

A:Converting Publisher to Excel... is it possible?

Read other 7 answers
RELEVANCY SCORE 49.2

Does the "OR" worksheet formula on Lotus convert to something else in excel?
Could anyone give an example (excel) of how to use the "OR" formula along with "IF"?
I have already used the conversion Wizard and the Formula did not convert.
 

A:Converting Lotus 123 to Excel

Read other 16 answers
RELEVANCY SCORE 49.2

dear all,

Am running Office XP pro. Doing an excel template and have a column that has running time in minute. I need to has a separate column that show in hours. Therefore I devide the min col with 60 to get the hour but it's in decimal ie 100min = 1.666 but i need it to show 1hr 40 min.

how do it do that? pls help. thanks
 

A:excel xp help (converting time)

Read other 7 answers
RELEVANCY SCORE 49.2

I have set up a spreadsheet that contains a list of things to do. I want to be able to enter the lette Y beside the ones that have been completed. Is there anyway to change the letter to a check mark.

I have already tried the autocorrect function, but this then changes all the letter Y in my orther spreadsheets.

Any help would be appreciated.

Thanks
 

A:Excel: Converting letters

Select the cells before doing find/replace. That limits how much changes.
 

Read other 3 answers
RELEVANCY SCORE 49.2

Good afternoon,

Does anyone know if there is a downloadable converter that will take a WORD document (extension .wps) on a computer running win 98 and convert it into an excel or word document on a computer running xp and office xp (extension .xls)
i have just changed jobs to a company i used to work for and due to the economic climate have not updated their computer system, and i was hoping that there was a program that i can add to my computer to allow me to read .wps and .wks documents generated by an earlier version of word, mainly to convert and store them onto a cd.

is there anything i need to look for on the free download sites?

best regards
phil
 

A:need help converting word 4 to excel etc

I don't know of a program that would do this. It seems to me the Word program that you have should determine if you will be able to use Excel with it or not. I would suggest that you request that your thread be moved to the Business Applications forum. You'll probably get more responses.
 

Read other 2 answers
RELEVANCY SCORE 49.2

I have a file given to me by our local tax accessor with all the info in need with one problem. The name field is one field which includes last first Middle initail example below

Smith John D

or

Smith John & Nancy

In doing a mailing I want it to be First Last (could care less about Initial or second name

Ant thought short of aadding commas to all 4000 names
 

A:converting csv file in Excel

Read other 12 answers
RELEVANCY SCORE 48.8

Hello. I have some .xls files on a cd which I could open fine until yesterday. The files were created on my Acer Aspire 5732Z (Microsoft Windows 7 Home Premium system x64 - based pc) using Microsoft Office Excel 97-2003.

Yesterday, I opened the cd on a different laptop (Acer Aspire 5733 64 bit operating system - windows 7 home premium, service pack 1). This laptop opened the files using Microsoft Excel starter 2010. I saved the files back to my cd when I'd finished, then safely ejected the CD using the correct method.

Now when I insert the CD into either pc, it show the CD drive but there are no visible files, so I can't open anything. I tried the error checking tool, but it can't check for errors as it says "windows cannot access the disk".

Can anyone help me open the files please? I have all the files backed up elsewhere, except for the two I worked on yesterday, but I really don't want to have to type them up again unless I absolutely have to as it will take me many hours. Any help would really be appreciated. Thanks in advance!
 

A:Solved: Cannot access Office excel 97-2003 .xls files after opening in Office Excel S

Read other 6 answers
RELEVANCY SCORE 48.4

Hi, This is silly but...

I have created a template on excel for printing my company cheques and what I wanted to know was:

Can I create a formula or macro so that when I write a number in text (such as 'one' or 'two' or 'three', etc) in the cell representing the word part of my cheque, can I get that number (as '1' or '2' or '3', etc) to appear in another cell representing the numerical part of my cheque.

This is a lazy man's burden but I thought it would also suffice as a check that the right amount was going on both parts.

Sorry for the bother but ...
 

A:Converting text to numerals in excel

Take a look at numbers alphebetic and numeric
 

Read other 2 answers
RELEVANCY SCORE 48.4

I'm trying to convert numbers to text in Excel for e.g. convert "1" to "one", "2" to "two" etc.

Any suggestions would be greatly appreciated
 

A:converting numbers to text in Excel

Fatmah,
I could not find a Worksheet function to do this, but depending how many changes there are and how many different numbers need to be changed, you may be able to do this with a VLOOKUP.

In a test I ran I had numbers with values from 1-12. I created a 2 column range elsewhere on the spreadsheet. The 1st column had the 1.2.3 numbers and the 2nd column had their text equivelent. I inserted a new column to the right of where the original numbers were and entered the following to the right of the first value I wanted to change. The vlookup looked like this =VLOOKUP(A4,$F$4:$G$15,2,FALSE) Note: A4 was the cell that had the value I wanted changed. $F$4:$G$15 is the range of the lookup array. 2 is the column with the text value.

Needless to say, this would not be a good idea if every cell had a different number or there were thousands of possible numbers to be converted, but if you had thousands ofmnumbers in a limited range, this might be helpful.
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Fatmah:
I'm trying to convert numbers to text in Excel for e.g. convert "1" to "one", "2" to "two" etc.

Any suggestions would be greatly appreciated<HR></BLOCKQUOTE>

 

Read other 1 answers
RELEVANCY SCORE 48.4

I converted a report from PDF TO excel. all of the information is stuck in Column A. I am trying to separate the information into different Columns with out having to copy and paste each item.

Is this possible to do. If so how?

Here are my examples
this is what i dont want

this is what i want

 

Read other answers
RELEVANCY SCORE 48.4

Hi all,

I'm having a bit of a problem in Excell. Whenever I save an excel file as text, it places quotation marks arrond any cell which contains a comma.

Has anyone ever encountered this or know how to resolve it?

Thanks
 

A:Converting Excel to text file

Read other 12 answers
RELEVANCY SCORE 48.4

Hi everyone,

I really need help with something that's driving me crazy. I am working on a spending report where I have a list of bank transactions on the 1st worksheet, and then subsequent worksheets are for each month of the year and other data on them.

I created this whole spending report at home on Excel 2007; however, at work where I need it I work on Excel 2003. I need help converting the below SUMIFS formula to a valid Excel 2003 version.

=SUMIFS('Master Spending Trans Summary'!C:C,'Master Spending Trans Summary'!A:A,'Jan. 2012'!A12,'Master Spending Trans Summary'!B:B, ">=" & "1/1/2012", 'Master Spending Trans Summary'!B:B, "<=" & "1/31/2012")

Whenever I've tried to convert it using SUMPRODUCT or SUM(IF, I keep getting either #NAME? or a #NUM! error.

Anyone who knows how to convert this formula, please please please help me!!

Hopefully someone can help convert this quickly, as I need it soon!

Thanks in advance!!
 

A:Help Converting SUMIFS to Excel 2003?

It's an old postin but I found this link that will help you out

http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003
 

Read other 1 answers
RELEVANCY SCORE 48.4

Hi

I just started to use MS Excel and I'm having trouble entering data in one specific catalogue.

In one column in that catalogue are digits, and what I have to do is to multiply them all by certain value and then add percentage to them.

Is there a way to do it quicker then one cell at the time, it okay now but as the info building up it will become a genuine pain in the you know what...

Thanks in advance
 

A:Excel help - automated process, converting etc.

Read other 10 answers