20 Most Recent
Microsoft Excel 2003 (065-03992) for PC Questions & Answers
Leble function
this is what you do, highlight the cell box that are being added to sum and click icon autosum
I have been tasked by my boss to discover a
save the file (use save as) before giving a file name under option/tools use a password to protect it
if a sheet is password protected then unless u know the password u cant open it....
i am note sure of there are passwored cracks...look in google
I need help with an excel formula.
=INT(A1)+0.95
With A1 being the reference to the cell you wish to round up
What that does is first round down the number to a whole one then adds 0.95 to the figure
Hope this gives you the information you need
Bob
Moderator
It would be very decent of you to consider the quality of our expert’s answers and judge them accordingly as you pass through FixYa.
Thank you
How to convert number into
enter the number in a cell in XL (i.e. 32568 or 32565 etc etc)
select the cell, right click
chose option - Format Cell
under Number Tab - select "Date"
on the right panel select a Date format of your choice
note - 32568 = 24-02-1989, 32565 = 25-02-1989 etc etc
How to convert figures to text. Eg. How to convert
This is not possible . The algorithm to read the possibilities is about 15 million to one!
The only method you can use is to manually time the information
Please rate my help++++Thanks for using FIXYA
"Delimited" gibberish in Excel
You could try to change the whole workbook font to a known good one or do it a sheet at a time by doing a "select all" then setting the font.
It sounds as if though you are trying to import a web page including the HTML code which may well cause the problem you see.
I prefer to do that type of thing with a
"Get External Data"
"new web query"
which will put things into a sheet in such a way as you can use them in other calculations
Whenever you open the sheet it will go and get the latest information for you automatically so you can then select what you want and copy that to another sheet. to use to keep track of things.
FILE REPAIR
the only solution is that reinstall your Microsoft office then it will ok...
My excel file was working yesterday, but as of
Shouldn't be a date issue... did you open the file the way you normally do ?
Something has changed here... bad shut down with this file opened... maybe.
Open Excel and pull down the File Menu and see if there are more than copy or version of your spreadsheet. Look at all...
File could have corrupted the Font or could be a Virus. Try just changing the font in one cell.
If this is your only copy of the file... make a copy to see if it works on another machine... that will isolate the problem... it may just be corrupt... the fix is Excel healing it on it's own when it opens.
Don't know what my product key is for microsoft
If you have the rest of the Microsoft office programs already installed and running, the number is the same. just activate it in the help dropdown. If you just bought it, the number is with the packaging. If you don't have it, contact Microsoft and they will provide tha number when you register your product. You will need proof of purchase so they know you don't have a pirated copy.
File name ocw.msi was accidentally deleted from my
try to restore windows
or use other file recovery software
for small files u can use glary utilities free edition-where file undelete feature is there. you can recover by searching through file undelete option.
if it helps
Rate me
Text and nos. in one cell, nos. to be used to create formula.
It is possible to do this using the right function.
I created your cells into a worksheet and it is very simple, although I have assumed that the last 3 characters in your cell will be the didigts you need for your formulae.
=RIGHT(B4,3)/1000000
Where the initial text contains more than 3 digits you can adjust for this in the in the formulae with everying else remaining the same.
The excelx files failed to convert
I think the excel fine you want to upload on the email is so large that's why it failed to load...
what kind of email provider you using??
the email provider have a limit capacity of file that they allow to upload on the email's..maybe your file exceed the limit that's why it failed to load or to transact.
Autosuggest Possible to use in Excel
As long as your list in Excel is formatted without missing cells in column format with a header in the cell directly above your first list time. i/e if your list is in Column A and you have 500 entries, I am assuming Cell C1 is the column header, and cell C501 is the last item of your list.
An easier way to view items similar would be to go to Data/ Filter and automatic filter.
In the arrow or list format in Cell c1 - select custom, in the pop up box you can filter the contains to highlight smaller elements of your list.
Excel 03 opens behind the toolbar
Assuming that you have some mistakenly changed the taskbar property that controls this:
1. Right click on your task bar
2. Select Properties
3. Un-check "keep the taskbar on top of other windows?
4. Click "OK" to save changes
Not finding what you are looking for?