Over 1 million tech questions and answers.

Solved: Works vs. Excel formats

Q: Solved: Works vs. Excel formats

I was trying to open .xlr (Microsoft Works) files in Excel 2007 (.xlsx), and it works to change the extension to .xlsx. The file extension becomes .xlr.xlsx. But then, I was also trying to do .wks (earlier Microsoft Works) to .xlsx, and I couldn't get that to work, even though the .xlr to Excel worked. Is there anyway I can get the .wks extension to convert to Excel like the .xlr worked?
Thanks, Jason

Preferred Solution: Solved: Works vs. Excel formats

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: Works vs. Excel formats

Read other 14 answers

does anyone know how i could change a column in a table that currently has dates in the m/d/yyyy format to mmddyyyy

here is an example

4/20/1991 to 04201991

this series of table contains hundreds maybe thousands of dates and I have to have the state report done by the end of the day any ideas would be appreciated

Thank You,

A:Solved: EXCEL Date formats

Dump it into Word and Use replace the / with nothing. Replace is gotten to via "CTRL-H"

Read other 3 answers

Hi, there,

I have this annoying problem. I am using Mac and the 2011 excel. I can easily get "too many cells format" error. But I checked using a third party software and actually I only have 217 formats in my spreadsheet. Don't we have this error only when we hit 4000 formats? Anybody has such issue? If yes, how can I get this resolved?

Many thanks for the help.

A:Solved: too many format error in excel (but only 217 formats)

Read other 7 answers

I am using VLOOKUP in a very old version of Excel (2000) to extract some data, nothing unusual in that except the data I wish to extract is of the following general format in each cell:

text A
text B
text D

It is important to keep the formatting, in particular the bold text, however VLOOKUP does not seem to preserve the bold formatting.

All help gratefully received. Thanks.

A:Solved: Excel - VLOOKUP keeping text formats

Read other 8 answers

Office 2010.

Outlook rule moves emails upon receipt from specified senders to an Outlook folder.
Outlook rule then runs a script that saves Excel attachments a directory on the PC, applying filename and filetype.
What I'd like to do is open the Excel file in the background and run some code on it before it is saved to the PC directory.
The code is just some simple clearing of formatting on each sheet:

Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
On Error Resume Next
Next wsClick to expand...

I have added the MS Excel 14.0 Object Libray to Outlook.

How do I tell Outlook to run Excel code?! Or is there another way to cleanse the formatting from the Excel files?

A:Solved: Outlook script to open Excel, clear formats, save

I've just found that the attachments we received can be in csv, xls or xlsx format, and all need to be saved as xls.
In testing a heavily formatted xlsx doc as an xls file, I find the resultant file is all full of horrible. Seems this is due to the compatibility between Excel 2010 and Excel 97-2000 (simply copying the data from the xlsx to an xls file produces the old Minor Loss of Fidelity window). I had wondered whether an alternative way to do it would be to open the attachment, copy the data and paste into an xls document (all using code). But it seems this would actually be more hassle.

If I (manually) clear formats from all worksheets in a workbook and save it as xls, I then can open the file (in compatibility mode) with no loss of fidelity warnings, and obviously no incomprehensible formatting characters.

This doesn't change anything from my original request, it just highlights the need to run Excel code prior to Saving As xls.

Read other 1 answers

I mean a program that can cut specific blocks out of almost any video file without having to re-encode all the data. Re-encoding stretches the time of the task considerably. VirtualDub can do this, but it only works with AVIs really. I convert files into a low quality AVI for usage on my MP3/Video player. Sometimes I want the file minus pieces of it (e.g. a TV show without commercials). The program I use (Format Factory) is good for conversion, but doesn't have a trimming function.

I download video files primarily in MP4 and FLV format, and I wanted to be able to cut them down before running them through the conversion process, rather than converting the whole file and cutting things down later in VirtualDub.

A:Is there a free video trimming program that works with all formats?

No. Many video files, like avi's, need to be re-encoded when something is cut out to recreate the index and the key-frames. You should be able to do most videos with VirtualDub and TMPGenc. A converter should help.

MPG's can be cut with any file cutter and have each piece still be playable.

Read other 3 answers


I've this strange requirement. I've 10 digit numbers in a column. These 10 digits can be any number from 0 to 9 and at any position. 0 can be the starting digit too.

I customized the cells using Format option and entered 0000000000 so that all numbers are displayed even with preciding 0's. All this comes fine. But when I pick up the number from another downstream applicaiton, it takes obnly the part of the number ignoring the leading 0's.
Can someone polease help me how to set this right!!!!!

Thanks in anticipation.


A:Excel cell formats


To what is the purpose of retaining the leading zero's for dependent calculations/manipulation? If you make the leading zero's permanent, this would effectively make the numbers text. Is that what you want?

If you want as text, here are some things you can do:

• Preceed the cell entry with a single apostrophe (denotes textual values and will be treated as such)
• Use a secondary cell to calculate your leading zero's (e.g. ..


..where A1 is your number entry)
• Use a routine like this in your worksheet module (right click Worksheet tab --> View Code)

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
'** Change A1:A10 to desired range of change
If Intersect(Target, Range("A1:A10")) Is Nothing Then Exit Sub
'** Add desired amount of leading zero values
Target.Value = "'" & WorksheetFunction.Rept("0", 10 - _
Len(Target)) & Target.Value
End Sub


Read other 1 answers

We are trying to control the date formatting in Excel cells.  The program gives many options to format an inputted date in a cell, and to change format for a column of cells, but no option is shown or accepted to make the format conform to  MM-DD.  june 14 is turning into J-17; but what is wanted is  either 6-14  OR   06-14.  In fact, cell not even accepting the data that is input.  Trying to type in  6-14, and then moving to another cell forces the just-input information to appear as  J-17.  This is very far wrong.  Does anyone know how to control this?
Windows 10, 64-bit
MS Office 2016

A:date formats in Excel

This may or may not help you. I use time groups in a similar manner for a two hour period 08-10 or 16-18. If you select the drop-down box in the number section, select "More number formats...", then select "Custom", you can make a format 00-00. Then the number will always display as whatever four digits you type in. If you type in 623, it will display 06-23. Not exactly a date coding, but may be useful to you.

Read other 4 answers

I have 2 reports that I want to merge which are exported from different applications.

The problem is that the names appear in a different format and I can't work out how to match them up.

The fact that not everyone appears on every report I have solved by using lookup as in the attached workbook.

What I need to do is use a formula that will recognise the two different name formats and match them up.

i.e. Campion, Ben P. and Ben Campion.

Please see attachment.


A:Matching Names in different formats in Excel

Read other 8 answers

So here is the issue. We use Excel 2000 over our network at work. I have a shared workbook that about 8 people have write access to. I make all of my formatting changes (i.e. margins, header/footer, layout, grid lines, etc.) and save it. I reopen it and all changes are saved. However, if someone else opens it and makes a data change then saves it, when anyone else opens it after that all of the formatting is changed. I have tried everything that I can think of to fix this and lock all of the formatting. Unfortunately, no luck. And wouldn't you know it, my company doesn't have a service contract with Microsoft for tech support!!! If anyone has ever encountered this problem, and/or knows how to resolve it, I could really use the help. Redoing the formatting everyday on five workbook pages really stinks.


A:Sheet Formats in Excel 2000

Welcome to the board.

>> If anyone has ever encountered this problem ...

Not personally.

>> Redoing the formatting everyday on five workbook pages really stinks.

Understood. Could you use macros to take out the bulk of this work?

Read other 3 answers

I'm fairly new to this, so please bear with me...

I have a production planning spreadsheet that is updated every week from a database to a new sheet. This sheet is 'Sheet1', last weeks update becomes 'Sheet2'.

Every day people annotate and colour cells for various orders, depending on their place within the planning scheme.

I've written a macro runs which finds the value in sheet1!A2 in the column A:A in Sheet!2 and copies the complete rows formatting into the corresponding row in Sheet!1. But my skill level only allows me to do this for the first row...I need to do this for all rows in sheet!1.

Private Sub Workbook_Open()
'Replicate comments from previous update

Application.ScreenUpdating = False
Application.DisplayAlerts = False



Cells.Find(What:=Range("Sheet1!A2"), After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False) _

Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

Application.CutCopyMode = False
Application.ScreenUpdating = True
Application.DisplayAlerts = True

End Sub

It's really only the formats that I need to copy across, I could use the VLOOKUP function for the values - So I suppose you could say I'm looking for a VLOOKUP macro which ... Read more

A:Excel VLOOKUP type code for formats

hi dwingfield - welcome to the forum.

Give this a twirl...


Sub CopyFormatsLoop()
Dim sh01Rows As Long
Dim sh02Rows As Long
Dim X As Long
Dim Y As Long
Application.ScreenUpdating = False
Application.DisplayAlerts = False
sh01Rows = Sheets("Sheet1").Range("A2").CurrentRegion.Rows.Count
sh02Rows = Sheets("Sheet2").Range("A2").CurrentRegion.Rows.Count
For X = 1 To sh01Rows
For Y = 1 To sh02Rows
If Sheets("Sheet1").Cells(X, 1) = Sheets("Sheet2").Cells(Y, 1) Then
Sheets("Sheet1").Rows(X).PasteSpecial Paste:=xlPasteFormats
Y = sh02Rows
End If
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub


Read other 3 answers

Is there a way to convert *.xlsx format to *.xls format without having MS office 2010.
I use MS office 2003 at home but they have upgraded to office 2010 at work.
I forgot to convert a file at work for home so is there a program that will convert
an excel spread sheet to office 2003 format?

Thank you,

A:Converting excel file formats *.xlsx to *.xls format

Read other 9 answers

Just wondering if there was a way to link cells in excel 2007, that would also link the formats. we change the precident cell to a different colour background to represent a different date, so making the dependant with it would be great.

I am also wondering what the best way to link a cell would be? the "paste link" function works well, but if i do more than one cell at a time, the dollars signs do not get pasted. I've tried typing "=" and then clicking on the cell. I think the main difference is the dollar signs, but just wondering what the positives/negatives of doing it either way would be, and what is the best way to link?


Read other answers


I'm hoping someone here can help me with this Excel issue.

I have a few Excel 2007 workbooks with thousands of rows of data over 80 columns. About fifteen of these columns are date formatted. In 2007 the format is perfect. I convert it to 2003, save and close the 2003 version. Open the 2003 version back up and ALL the date columns have switched to general. (shows only 42293, etc).

Changing the fields to date doesn't seem to do anything as the moment I close and reopen the excel file it is converted back to General. Its like Excel 2003 is storing these values as Number instead of Date.

My first short-term solution was to copy the entire spreadsheet and Paste-Special into a new workbook but I am supposed to use these files month after month. My second solution was to manually enter an apostrophe before each date but that caused problems as the field was then read as a text field instead of a date field. Plus it was majorly time consuming.

I don't seem to find a reliable solution to this issue on the Microsoft website and I've only seen one other example that gave the above solutions as their replies. I'm stuck...

Thank you for your help!


A:Excel 2003 Formats ALL date columns as General

Hi there,

Strange indeed. Is this in one of the files, or all of them? Do you have any macros in the file? I can't recreate your error. Can you recreate this in another file? And if so, can you post it?

Read other 1 answers

I have created a fairly complex Excel template file and I've hit a point of confusion.

With the file, the user can drop a couple of large blocks of data into it from external files, and click a button and the VBA will process them, stripping out unnecessary data etc, moving the data to a sheet which applies lots of formulae, populating a couple of pivot tables and saving.

Performing this processing is the kind of job you set running last thing before you leave work, and deal with the file the following morning. Both of the data files it uses can contain 16 columns and upwards of 50,000 lines of data, and my file includes about 30 formulae fields on one sheet and 10 on the other. Many of these are lookups from 1 sheet to the other. In the last full test, the processing took about 90 mins to run, popped up my msgbox saying it was going to save, and then took nearly 40 mins more.
The resulting file is around 50Mb, and if closed, can take over half an hour to re-open.

I also have a "cleanse" macro which strips most of the data back out, but the last couple of times I've run this on a file full of data, it's killed it, leaving it corrupt / broken.

So far, so horrible.
I've tried to do various things to speed it up:

- Amending many of my formulas, such as stopping the doubling up of VLOOKUPs to hide #N/A errors, converting most vlookups to INDEX-MATCH, etc
- Amending the VBA, including cutting the use of Select / Selection, turning off screen up... Read more

A:Excel VBA - Paste special formats & values to another workbook

Hi, I've read (and think I got most of it) but just for my interpretation.
You say you have an Excel file with a large ammount of formulae, vba code etc whihc servers as a template, corect?
Okay, if this assumption is correct that means that this file, apart from all the formulae and all is empty (no data), correct again?
If this is the case what you need to do save it as a template file, it will automatically be save under the templates in Excel.
No macro needed for that.
When you open a template file it will always open as <name of the template file>1, 2 or whichever during a session.
When closing it will always promt for a (new name) thus avoiding you overwriting the template file. Do you think this would work? Have you tried this?
If not, let me know, I use other methods but this is the simplest one and you do not need to select every sheet, you just save as and the filename you want.
Let me know, If i got the time, I'm what you might call a masochist I love these vba challenges

Read other 3 answers

I have a list of events with dates that I want to enter in an excel worksheet and my problem is that the dates are not formatted the same:

-some are full dates and enter fine (day, month, year)
-some are month year only
-some are year only

Does anyone have any idea how I might get these all into one worksheet and be able to sort them?

I've read all the Microsoft stuff on how excel codes dates from Jan 1, 1900, so I'm dubious that there is a solution, but I would love to hear any ideas that might work or a suggestion for a workaround or other application idea for collectiing this data. It's a large project for a charity and they know less about excel than I do <g>.


Tom O'Connell

A:Excel date format - multi formats allowed?

Read other 9 answers

First time poster here,

I need help writing a macro which I will link to a button. Here is what I'm looking for:

I have 4 columns of data starting in rown B29 and ending in G29 (one of the columns is actually 3 merged columns which is populated by a dropdown list). 2 of the columns have formulas.

I would like the user to click the button, which will add a blank row with all the formatting from above (including the same drop down list and formulas). However, I would like to be able to add multiple lines and have the new line always appear at the end of the list.

As if that weren't complicated enough. I want to add another button to act as a 'reset' button which will delete the added rows, leaving me with the original blank row.

I tried recording my own macro but that doesn't work because the merged cells un-merge as the new row is added. And I can't get the new row to always appear at the bottom if I add more than one.

Is that enough info?


A:Excel Macro to Add Line while Copying Formats/Formulas

Read other 6 answers

Hi. After getting my wife's laptop with Win 7 Pro to run it's updates again after a week's worth of struggling with that, she opened an existing LARGE spreadsheet to find that all the green cell contents were now blue, and the cells with $ formatting were now general format again !! Not a happy camper !
Has anyone ever experienced anything like this after Windows Updates ? Could something have affected the palette settings for the colors ? Over 120 updates (mix of security, Office 10, net frame etc.) were done so a little tough to identify the potential culprit.

Thanks for any insight.

A:Excel cell formats changed after Windows Update

No, I've never seen that. I have a bunch of color-coded Excel stuff, but updates have never affected it.

You may have to do a System Restore to a time before the updates, if you'd rather give up the updates than deal with the Excel issues. I assume the Excel formatting issues can't be easily corrected.

Read other 2 answers

Hi all,

How do you ensure excel autohides blank rows that are in various formats and still shows values that do have values? (eg. $.00)

This thread has helped:


However, for some reason - if the cells are in $.00 format and have values in them - they are also hidden.

Thank you,

Read other answers

So working with custom formats for cells (under Right Click Cell > Format Cells...> Number Tab > Custom), Excel will list a few default custom formats like this (I'm talking about the right side that starts with General, 0, 0.00, etc.). When I enter my own custom formats  they will appear at the bottom of the list.  I'm noticing Excel adding random formats to this list, about several minutes or more after I start a workbook. If I close Excel and re-open it the random formats are gone, but they sometimes return after working on the workbook for some time.  Right now these are the five formats that are consistently appearing without me entering them:
[$€-x-euro2] #,##0.00_);[Red]([$€-x-euro2] #,##0.00)
They don't show up in this list when I start Excel, so I know they aren't default custom formats and I'm not adding them in myself. I wasn't even using formulae in one of my workbooks and they appeared, so even if a formula caused Excel to automatically generate a custom format, I'm still experiencing the problem even when I haven't used a single formula on a workbook.
What is going on with this?

Read other answers

So working with custom formats for cells (under Right Click Cell > Format Cells...> Number Tab > Custom), Excel will list a few default custom formats like this (I'm talking about the right side that starts with General, 0, 0.00, etc.). When I enter my own custom formats  they will appear at the bottom of the list.  I'm noticing Excel adding random formats to this list, about several minutes or more after I start a workbook. If I close Excel and re-open it the random formats are gone, but they sometimes return after working on the workbook for some time.  Right now these are the five formats that are consistently appearing without me entering them:
[$€-x-euro2] #,##0.00_);[Red]([$€-x-euro2] #,##0.00)
They don't show up in this list when I start Excel, so I know they aren't default custom formats and I'm not adding them in myself. I wasn't even using formulae in one of my workbooks and they appeared, so even if a formula caused Excel to automatically generate a custom format, I'm still experiencing the problem even when I haven't used a single formula on a workbook.
What is going on with this?

Read other answers

Hi all,

This is quote from the "Microsoft Excel 2010 by John Walkenbach" book:

"Clearing formats doesn't clear the background color in a range that has been designated as a table unless you replace the table style background colors manually".

But, When I create a table and right click -> format cells -> Fill -> background color and then chose a color then OK.
After that I chose all cells of that table (which now has a background color) and the Clear->clear formats.
But the background color also will be cleared. Why? The wrong is with my work or the book's text please?


A:Excel, Clearing formats doesn't clear the background color

I cannot see why Clearing cell formats would not clear the Colour formats as well. This would be the logical approach & also why would you want the cell colour remaining if you have cleared the cell format.

I suspect that your 2010 manual may have an error & not your work.

Read other 4 answers

I've got a problem with a file I have inherited. It is very complex but works beautifully,... until now. The Macro suddenly has a run time error and crashes out on the first line. When I back the data up by one month, it works fine. There is no change in the script at all. The previous manager of this file mentioned something in passing about how the macro doesn't work right if the file is copied (or something like that) for some unknown reason.

Please Advise.

A:Solved: Excel Macro works before, but not now???

Read other 12 answers

I am trying to count the number of times a particular word appears in column K, when I use the COUNTIF command =Countif(K9:K80,"Inhouse") I am not getting any values returned even though the word Inhouse appears in this range.

When I try the same command on a different column =Countif(H9:H90,"PP NBE") it works fine.

I have confirmed that the data type is text for the range in both cases. I even tried copying column K into column H and that didn't work.

Is there a secret handshake I'm missing?


A:Solved: Excel COUNTIF - works in one column, not another

Turns out there are extra spaces after the words in column K so I have to replace the content with the same content but without spaces.

Does anyone know a less messy way around this? Can I use a wildcard after "Inhouse*" or something?


Read other 3 answers

I have a macro that I have used for a very long time with no issues. It appears to be something with the number of records. I use it to copy and paste from one worksheet to the bottom of the other. I used it with no problem yesterday when I had 31896 records but with 31982 records today, it errors out with copy and paste are not the same size and shape.

Dim UsedRng As Range
Dim FirstRow As Long, LastRow As Long, FirstCol As Long, LastCol As Long
Set UsedRng = ActiveSheet.UsedRange
FirstRow = 2
FirstCol = UsedRng(1).Column
LastRow = UsedRng(UsedRng.Cells.Count).Row - 2
LastCol = UsedRng(UsedRng.Cells.Count).Column
ActiveSheet.Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol)).Select
ActiveSheet.Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol)).Name = "END"
ActiveSheet.Range("END").Copy Destination:=Sheets("CANOPI - Link report").Range("A" & Rows.Count).End(xlUp)

A:Solved: Excel VBA Copy & Paste no longer works

Well, I just tried it manually and it did the same thing. The only difference I can see is the number of records.

Read other 2 answers

I have an Excel 2000 spreadsheet that contains several macros which ran fine under Windows 98SE. I finally broke down and upgraded to a new machine running XP Pro, and discovered that one of the macros doesn't run properly. What makes this perplexing is that there are three very similar macros in the spreadsheet, and only one of them is giving me problems.

The macros in question shell out to run external programs, which receive a selected cell value as a file name argument. The macro that isn't working calls a program I wrote called ReplayQk. Because of the way ReplayQk is designed, I can distinguish between cases where the program can't find the file it is passed (displays a "can't find it message") and cases where no argument is provided at all (presents a dialog box that allows the user to sepcify the file). Based on this I can tell that the program isn't receiving the argument. But another macro that is doing essentially the same thing is working fine. Finally, if I run ReplayQk from a command line and provide a filename argument, I works fine.

Below is a copy of the code for two macros, one that works and one that doesn't. And, in considering this problem, remember that both of them work under Win98. So, anybody have a plausible explanation for this?

Sub RunWinquake()
' Pass a selected event file to Winquake for execution. The
' event file is selected by selecting the event file name in
' the spreadsheet.
&... Read more

A:Solved: Excel macro works under Win98, doesn't under XP Pro

Read other 16 answers

Open XML formats or OpenDocument formats - which one should I choose?

When installing Office, which is the better choice
I thought XML - I know the XML file structure

But then something like Apache Office (or whatever it's called) use the OpenDocument format (I think)

Any advice would be great


A:Open XML formats or OpenDocument formats - which one should I choose?

Hi there,

The OOXML documents are more widely used/accepted. The Open Document Format (ODF) became prevalent around the onset of Office 2002 (consequently right around the time Microsoft began exploring the creation/acceptance for OOXML) and gained quite a bit of popularity, due to its open-source approach (eg. OpenOffice app), but with the advent of the OOXML format, along with its many benefits, has become the de facto standard, which goes above and beyond what the ODF (originally developed by Sun Microsystems for OpenOffice platform) standardizes. This has been a highly politically charged debate for well over the last decade. Personally, I like a widely accepted standard, which I think the OOXML format provides.

A good read:

Read other 2 answers

I have a fairly larege and complex workbook, and have started getting this error. I got rid of some sheets that I didn't need,a dn the error went away for a while, only to come back.

The worst case was when I saved a workbook, and tried to open it -- and got the error, and couldn't open the dumb thing. I sent it to others to see if they could -- no luck.

Anyone ever come across it? Ideas to fix, other than the obvious of getting rid of stuff. Thanks.../B

A:EXCEL: "Too many formats" error...

Bet you got a bunch of charts, huh? Lemme know.

Read other 3 answers

Basically each morning I import data from an internet database to excel.
I need to divide the number of rows, that i receive daily in this excel document, to 4 worksheets designated to 4 staff members.
Each staff member needs to receive an equal amount of rows.

For e.g. if today i received 124 rows of data then each staff member should get 31 rows each.
Except the number of rows will vary on each day. I could get 200 plus rows of data.

Can someone please assist with writing a macro to divide up the rows in to the 4 worksheets? I would be very appreciative. Thanks in advance

I have attached the sample file for viewing....the data starts from row 3...thanks

A:Solved: Excel Macro to divide any number of rows equally onto certain number of works

Read other 11 answers

I have a Philips GoGear Vibe MP3 Player which only appears to correctly 'index' MP3 files whose tags have been created in other systems.

If I rip the tracks from a CD within MS Media Player and then synch these to the GoGear then they are included within the Artist/Album indexes. However, if I copy tracks from another source (CD ripped and tagged with Linux Rhythmbox and/or using Easytag) into the Windows Library and then synch these to the Philips player, the tags don't appear to be recognised and the songs are listed under Unknown Artist/Album rather than being indexed properly.

I can still access them via the folders view but not via the Album/Artist menus.

So it would appear that the Philips Player is looking for/finding some info that MS Media Player adds to files that it 'rips' that are not part of the 'standard' MP3 tags edited by other systems.

Does anyone know what/where this information is held?

A:Solved: MP3 Tag Formats

Read other 6 answers

I have been using CD's for many years and now am using DVD's. Is there a source on the net or in a book that explains the advantages of the various formats and in CD's the MB size. This sure is a wonderful place to get answers forsome of us who dont know a lot or don't retain what we have for very long.Ha


Read other answers

how to run xp formats like-
doc files, exel files ?????????????in windows 7

A:Solved: run xp formats

Even in windows 7 you need the correct application installed like Microsoft office to run .doc and .xls files

Read other 3 answers

I got a new Seagate 320BG from Tiger Direct yesterday to replace a Maxtor One Touch drive that died.
When I installed the drive in the case and activated the drive, the only option was to format the single partition as 128 GB.
Long story short, I removed the drive from the case, changed the jumpers, connected via USB without the case and got the same result.
Tiger is replacing the drive, but I wonder what's going on here?
I've replaced, formatted, partitioned many drives, but I've never seen this situation before. Tiger Tech support tells me it's not unknown to them, but they had no explanation.
Has anyone seen this before?

A:Solved: 320 GB HD formats as 128 GB

Read other 14 answers

Hi folks, could some one tell me how to change back file formats.
I recently got Paint shop pro 7, and scand some piccys onto me p/c so I could email em to family, well to cut a short story even shorter all my cartoon and pics now open up in paint shop pro 7 instead of netscape.
I would be indebted to any one who could tell me how to switch em back again, cheers inadvance

A:(Solved) file formats ?

Read other 6 answers

I have some very large Excel spread sheets and for some reason I now get a message "Too many different cell formats"

This has only just started the last few days, am I low on Cache, can I change the value.

The above comes up with just 3 date cells of 2 colours highlighted, and has come with a single cell a couple of times.

If I save and close the file then reopen It might work a couple of times max, then up comes the same message.

Running Word 2000 XP pro SP3 all up to date.

Any help would be greatly appreciated.

A:Solved: To Many Cell Formats ?

It seems Excel has a built in limit for the number of format changes, around 40,000 I believe.

This can not be changed within Excel or by a download from M$ that I can find.

However, if you download and install (Free) "Open Office. Org," open the offending file the problem is resolved.

I found this work round by spending a lot of time trawling the WWW.

Hope this will save some other soul the time and effort required.

Read other 2 answers

I use Open Office for word processing. I have a chart I want to send to someone that uses MS Word. However, when I convert the odf to doc format, I loose the chart representation. Is there a work around?

A:Solved: Charts in odf and doc formats

Use a snipping tool of some sort to take a screen capture of the chart, then insert it into the Word document. I know, it's a bit clunky, but unless someone else has better idea...?

Read other 3 answers

Does NTSC format & PAL format work the same on the platform PC, or is it not an issue being playstation and xbox and other systems, Jargon.

And pc-dvd rom , pc-cd rom whats the diff, all the same on pc-?

Just a simple Q for a difficult mind

A:Solved: Formats : NTSC & PAL

I think that NTSC is used in US, Japan,Mexico and Canada and is 352x240 resolution and has 30 frames with around 525 lines and PAL is used every where else and is set at 352x288 with 25fps...As for if it works on the PC platform, it depends if the device is able to play back "both" PAL and NTSC as alot of newer consumer electronic devices (DVD players and TV's) are both PAL and NTSC compatible. I'm not sure how Playstation and Xbox handles that..I think they might keep the NTSC on NTSC and PAL on PAL and not compatible, but I'm not sure..

Not sure if this is answering your other question, but a PC-DVD Rom is a DVD and a PC-CD Rom is a CD..since most players are "superdrives" that can play both CD/DVD's, the main difference between the two now-a-days is really just the capacity that it can hold and the read/write speeds..

hope this helps!

Read other 2 answers

I am running vista,and windows media player11. I have Real player(with no adds)installed. I downloaded a torrent -and neither of these will play the files. They are .ro, eg.roo..ro1,.ro2.What do I need to play these files?

A:Solved: video formats

Read other 8 answers

I'm trying to play some videos on my computer, but I can't seem to open them. They are .mkv and.ogm formats. Anyone know of a program I can use to watch them?

A:Solved: Weird video formats...

Try VLC media player. I've never tried playing either of those formats, but according to their website


it will play both Matroska (MKV) and Ogg Vorbis Video (OGM).

Read other 2 answers

NOTHING will play, really confused.

in media player I get an error that reads:

Windows Media Player cannot access the file. The file might be in use, you might not have access to the computer where the file is stored, or your proxy setings might not be correct.

[Close] [Web Help]
web help is worthless of course. This happens when I try to play any media file, avi to mp3 audio and video files. any ideas?

EDIT: Also, when I try to open them in NeroShowtime (my other player), It just says Error Reading file. VLC Player will play the file fine, but with no audio.

A:Solved: Errors on all media formats.

Read other 10 answers


I've spent most of my afternoon trying to fix this but I've finally bitten the bullet and asked for help.

I have a list of data with dates and times (more than 5000 overall) where the date/time field is in one of two formats:

A. 02/09/2013 13:00
B. 2/09/2013 1:00:00 PM

In option A I can change the format of the data whereas in option B, regardless of the data format I impose, nothing changes. I need to sort the data by date but all records which are set out like option b refuse to be recognised as dates so aren't sorted.

Is there a way I can manipulate data shown as in option B so it can be recognised as date and time like it is in option A.

I'm not sure if I have been very clear so please let me know what other information you need.


A:Solved: Date/Time Formats

Read other 6 answers


I'm doing recording in C++, opening through waveInOpen(...). In the PSDK,
recording in WAVE_FORMAT_PCM has been simplified with values for
nSamplesPerSec, wBitsPerSample and cbSize and
deriving values for nAvgBytesPerSec, nBlockAlign provided.
What values do we assign for the above fields in recording in the
GSM,MS-ADPCM,A-LAW and U-LAW formats ? Or can someone provide
a link to information about these?


A:Solved: Recording in NON-WAVE_FORMAT_PCM formats

Well, I found useful information in the sites below:

1. http://netghost.narod.ru/gff/vendspec/micriff/ms_riff.txt
2. http://www.winehq.org/pipermail/wine-patches/2002-May/002481.html
3. http://www-mmsp.ece.mcgill.ca/Documents/AudioFormats/WAVE/WAVE.html


Read other 1 answers

I want to convert some of my MP4 files to mp3 or wav formats. Can anybody tell me a name of a good freeware for this? Please give me the URL (Oh another thing; please be sure that your URL and software doesn't contain any malwares.) Thank you.

A:Solved: software to convert mp4 to MP3 or WAV formats?


Read other 2 answers

My computer defaults to quicktime picture viewer to look at pictures. I much prefer the JPEG format, but am too deficient to figure out how to make my computer change formats on my own. Is it an easy thing to change formats, and will all the pictures I have saved be automatically converted when I change the format? Any help would be most appreciated! I have a pentium machine, with Windows 98SE.


[This message has been edited by agent2x4 (edited 01-09-2001).]

A:(Solved) changing picture formats

Try this. Locate a picture file in Explorer and while holding the shift key down right click on it and select "open with" on the menu. When the open with screen pops up scroll down and click once on IExplore or Explorer to highlight it and then put a check in the little box where it says "always use this program etc..." and then click ok. Then your pics will open in a browser window when you click on them. If you would rather have them open into another viewer such as Adobe Photoshop or whichever then select that on the "open with" list instead. You can always change it using the same method.

Read other 3 answers


First Happy New Year

Is there a way to modify the following to recognize a date that has the format: 2/27/12
(m/dd/yy). This one only recognizes the standard format: *m/dd/yyyy
I just want to know in case I need to write a code that has to fine a date with different formats.
Sub finddate()
On Error GoTo Errorline
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveWindow.ScrollRow = ActiveCell.Row - 15
Exit Sub
Errorline: Call newopen
End Sub

What the code does is look for today’s date in A:A, move over one cell and down to the first empty cell where I can add data.

If it doesn’t find today’s date, it goes to yesterday’s date and again moves over one cell and down to the first empty cell. Then a messages box pops up and asks if I want today’s date entered (newopen). If no, then it ends. If yes, it brings up another sub that puts todays where I need it (with.. copy-pastespecial-value) moves to the right one cell and I can add data.
A:A will always have yesterday’s date and sometimes today’s date.


A:Solved: have a macro recognize different date formats

If your m/dd order is the same, you shouldn't have much problem.

Read other 2 answers

Our Helpdesk application stores all notes in large memo fields (almost BLOBS) and does it with rtf format codes in it.

I am looking for a way to extract / show only the text.
We use MS-Access routines to do this.
I have a workaround and depending upon the ammount of text in the NOTES field (large MEMO) it takes very long to remove all the unnecessary RTF code leaving only as much of the plain text so that it can be used in reports or queries.

I have attached the textfile containing the module with then function RTF2Txt I use now.

I would appreciate any suggestions.

I know that using other applications will simplify matter but we must have this in MS Access

Any help tips or suggestions, code advice etc etc is welcome.

Sample text file which some contents added

A:Solved: MS Access Remove RTF formats to read the text

Read other 16 answers