FIX FOR SBERET.MSI MISSING FILE
Try creating a new folder called 'XLStart' in your Office10 program
folder which is located in the Microsoft Office folder in programs.
This fixed mine. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142281
256-Column Limit: No More?
If so, what's the earliest version that allows more than 256
columns?
--
PeteCresswell Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142279
VLOOKUP Question
I use VLOOKUP all the time but I now have a workbook with multiple
worksheets. Each worksheet has different product groups. Each product has a
unique product code (catalog #). I would like to retrieve three pieces of
data.
PRICE
PKG. QTY
PKG. WT
I have a master worksheet with all of the product codes.
Is there anyway I can use VLOOKUP or is there some other formula I should
use?
Thanks to all in advance. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142273
Excel 2007 - Nothing shows up in the cell while I'm typing!
I'm running into an issue with a range of cells in a spreadsheet where
nothing shows up in the cell as I type. I can see the cursor moving
to the right to show that I'm typing something, but the value that I'm
typing doesn't actually appear in the cell until I hit <Enter>.
I'm maintaining a large workbook with lots of formulas and named
ranges. It was built by someone who no longer works here, so I'd
rather not blow it away and start over. It appears it was built using
Excel 2003. I'm now managing the file in Excel 2007. I've been
adding records to this spreadsheet for several days now and didn't
have this issue. But now all of a sudden, I get to a certain row (in
this case, Row 1776) and nothing I type shows up until I hit enter.
If I clear the contents of any row above row 1776, I can clearly see
everything as I type it. But with Row 1776 and beyone, I can't see
what I type.
I am able to see what I'm typing in the formula bar at the top of the
page, but not in the cell itself.
Any help would be greatly appreciated! Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142262
lost in 2007
Hi,
I have just upgraded from Excel 2003 to 2007. I was disappointed to
realize that:
-my toolbar customizations were lost: Of course, toolbars are obsolete
in 2007, but I hoped that I could at least recover my custom buttons in
the Quick Access toolbar...Any comments?
-I have created lots of useful vba functions that I had regrouped in an
xla file placed in my XLstart folder so that they would be always
available. I have no idea how to achieve the same functionality in 2007.
-I also had a few custom functions in my personal.xls (in the XLStart
folder). I assume that it doesn't work any more in 2007 since none of my
custom functions are available.
Gee, and I'm supposed to migrate 3000 users this fall!!! I'd better find
workarounds for these issues or hire body guards...
Thanks,
Lo Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142260
Excel.exe is not a valid Win32 Application.
My system: Vista Business 32bit with SP1, Office 2007 Professional with SP1.
For a while I was running Vista (without SP1) and using Office 2007 with
SP1. Rarely any issues.
Sometime after installing Vista SP1, I've been having odd issues with my
Office installation, Excel especially. I don't know if it's its SP1 related,
or if it's just something went wrong with the Office install.
Here's the issue. I leave my PC on 24/7 and simply lock it when I leave the
office. After several days, Excel will just stop working, completely. When
I try to launch excel I get the error "Excel.exe is not a valid Win32
application".
I have tried reapplying SP1. After reapplying the SP1 and rebooting,
everything returned to normal. So I thought. A week or so later, same
issue. It turns out simply rebooting resolves the issue temporarily.
I thought my Excel exe was corrupted (i.e. some file wrote/deleted
information from the binary file). I verified modified dates with other
excel exe's and everything is the same. Nothing seems out of the ordinary.
I can't find any relevant errors in my event log. I can't see anything out
of the ordinary when using SysInternal's process monitor either. It's like
something in Vista thinks this EXE is a bad EXE and it won't let it launch
until I reboot.
I have even noticed after several times of launching the exe, if I browsed
to the installation directory, the actual icon for Excel was dimmed, as if it
was like a hidden file or something. WTH? When I rebooted, it returned to
the normal icon. I have yet to see the icon dim again, even during times of
issue.
I disabled my antivirus thinking it was the culprit to no avail.
What in the world could be happening? When I use the process monitor, the
exe never even gets executed (i.e. no events for excel.exe).
Please help!!!
-Matthew Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142251
Advanced filter for groups to in Excel
Hello - I have a server inventory list that I'm trying to organize for
end users based on what group the servers belong in. Some servers
belong exclusively in our "Staging 1" environment, some servers belong
exclusively in our "Staging 2" environment, and some are shared
between the two. I have a column that is named, "Environment" and
right now I have assigned the exclusive servers to their appropriate
groups however the ones that are shared need to be categorized by
something like, "Staging 1 and 2." The problem I'm facing is that I
want someone using the spreadsheet to be able to filter based on no
more than the two environments - Staging 1 or Staging 2. If someone
filters to view either one of those groups then he or she should see
the servers in the "Staging 1 and 2" group as well because they're
shared across both.
Does anyone have a solution? Thanks in advance!
Charlie Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142244
always save backup
Can someone please run me through the drill to configure Excel 2002 to
always save a backup file when the original is saved.
Thanks,
Ron Patterson Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142241
Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
Florida Miami
Florida Orlando
Florida Tampa
Florida Jacksonville
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
Jacksonville
California Los Angeles San Diego
Any help is greatly appreciated.
Thank you! Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142240
Always show the content of a specific cell in the frame of Excel
Is it possible always to show the content of a specific cell in the frame of
Excel (so you always can see it). Then it is possible always, for examble, to
see the sum of some cells, when you are filling the underlying cells with
numbers.
In QuattroPro ver. 8.0 this was possible. In Danish this cell was called
"Lyncelle" - perhaps "Quick-cell" in English.
Best wishes
Niels Danstrup Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142238
formula to turn hh:mm cell into x.y hours
I need to track billing for a client, with 1/10th hour precision, and where
partial groups of 6 minutes round up to the next 1/10th hour (example: 8
minutes = 0.2 hours). I have a start time, and an end time. Then I
subtract one from the other and get hh:mm, such as 1:08 which represents 1
hour and 8 minutes. So far so good. But then I want a formula that
converts that to 1.2 hours. But everything I try is failing. I can't
even figure out how to convert the 1:08 to 68 minutes. Please help me with
the formula for the cell below:
Start Stop Duration BillableHours
8:00 9:08 1:08 ?????
????? should show 1.2
Thank you. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142231
save as pdf crashes
Hi,
I am having difficulty with the Excel 2007 'save as pdf'
functionality. I have posted the troublesome file at the link below:
http://dollar.biz.uiowa.edu/~jgoodson/TestRecourse.zip
When attempting to save the 'chart1' worksheet as a pdf file, Excel
stops working and either closes or restarts. In both cases, the pdf
file is not created. I am able to save other Excel documents as pdf
files, but, for some reason, this one refuses to be converted to a pdf
file. I have reinstalled the 'save as pdf' add-in from Microsoft, but
this doesn't help. I appreciate any advice.
Thanks,
Justin Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142230
Tab to specific cells
I am using excel 2002 and my boss 2003. I want to tab to specific cells in
my work sheet. Can anyone help me get started? Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142226
Excel ignoring date format when saving to Text
Hi,
I have a spreadsheet that look fine on the screen, perfectly formatted
date wise. It's a 2003 SP2 spreadsheet. When I save it to text (Tab
delimited) or any other text format it reverts to mm/dd/yyyy formating
instead of british dd/mm/yyyy.
I've checked all the regional settings on the machine and nothing
appears to be wrong with it. Prior to an upgrade to 2003 it was
working fine. I tried installing excel 2000 aswell but now that
doesn't work either.
Any help appreciated.
Thanks,
Matt Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142223
Greyed Out - Compare & Merge Workbooks Function
Excel 2003 on XP.
Regardless of how I try to get this to work, ie opening different files in
different sequences, this function is never available.
I have followed the Help on Merge Workbooks but it is still greyed out.
Any ideas anyone.
Many thanks
DeanH Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142212
Problems referencing dates with the MATCH formula
I am finding this a little unpredictable. Sometimes it works fine; for
example:
A B C D
Date Mar-08 Feb-08 Jan-08
If I wish to return the column number from the dates:
Mar-08 =MATCH(A2,$A$1:$D$1) returns the value 2
Feb-08 =MATCH(A3,$A$1:$D$1) returns the value 3
Jan-08 =MATCH(A4,$A$1:$D$1) returns the value 4
However if I expand the reference to include column E, Dec-07 I get
this result:
Mar-08 =MATCH(A2,$A$1:$E$1) returns the value 5 (which is the total
number of cells in the reference).
Can anyone explain why this would be the case?
(The dates are actually 01/03/2008 (UK style) but I have used custom
format to display them as mmm-yy. Also the dates are always the first
of the month.)
Then next part of my question is a little more complex.
In column A I have a product names
In column B I have the first date that this product was sold.
In Column D to A I have the product sales by month.
I would like to use the AVERAGE formula in in column C to calculate
the average sales over time.
However not all products have the same history; some are more recent
than others; products have the value zero in the months before they
appeared.
Therefore if a product has been around since the start the formula
will be =AVERAGE(D2:Z2)
But if the product has only been around for the past three months the
formula will be =AVERAGE(D2:F2)
I would like to use the MATCH formula (or a similar formula) to
replace the second cell reference in my AVERAGE formula. That is, a
nested formula that references the values in column B (the date the
product was first sold) and returns the appropriate column reference.
I hope I have been clear. Can anyone help with either of these
question? I would be eternally grateful.
Harry Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142207
Referencing Dates with the MATCH formula
I am finding the MATCH formula to be a little unpredictable when used
with dates:
Sometimes it works as I would expect. For example:
A
Date, Mar-08,Feb-08,Jan-08 Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142205
Help with printing gridlines
I have a wksht where I can see the gridlines, and have selected a checkmark
to print out with the gridlines. However, if I do a print preview or print,
the gridlines are missing in the output. I must have turned something off
accidentally.
Bob Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142201
date reformatting
I have a date m/d/yyyy and would like to convert it to mm/dd/yyyy. I tried
format-custom-mm/dd/yy but it is returning m/d/yyyy can someone help me out? Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142196
Groups? Discussions?
I am thoroughly confused! Over the weekend (and now of course) I posted
questions in this â??areaâ??. When I got to work this morning and started
looking for the posts, I found that at work I have set my favorites to look
for Excel questions in an â??Office / Communityâ??. I now know why I have a heck
of a time finding all my posts and answers.
Can someone please direct to someone, or something that will clear up what
the difference is between Forums, Discussion Groups, and Newsgroups on
Microsoft.com, and which one I should be using? They do not appear to be the
same. Thanks. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142191
Help with formula
I have 2 pages
Page 1 is booking form
In page 2 I am doing this ='Booking Form '!J11
This refers to a name on the booking form, however it shows ='Booking Form
'!J11 instead of John Smith.
This works ok for the other cells.
What am I doing wrong? On page 2 I press = and then click on the cell J11 on
the `booking form` page and press enter.
thanks Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142187
Cannot open shared Excel file because it is locked by own id
A fellow user maintains an Excel file on a Windows Server 2000 box
that is shared across a network. This user accesses the Excel file
from his desktop which is running Windows XP SP2. Frequently, he
cannot open his shared Excel file because it is locked by his own id.
This problem persists for hours but at the longest is cleared up on
its own by the next day. He does not have the Excel file open and
there is no instance of process EXCEL.EXE executing on his desktop PC.
I have tried asking him to:
1. Close Windows Explorer because it
can read data about the file and hence leave it open.
2. Reboot his PC
3. Login to my PC using his User Id
All to no avail. I have little control over the Window Server 2000
box hosting the shared Excel file in question. Is there anyway to
further isolate the problem? For instance, are there known problems
with Windows Server 2000 opportunistic locking support? If so, what
fix level was it corrected in?
Any help would be appreciated.
--Thank you,
--Mike Jr Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142186
Forcing a cell to be formatted as text - when using the Match Index
Hello - I am trying to do use the Match and Index functions to perform
a Vlookup. However, the column for which I am attempting to match
values will not convert to text format (thus disallowing me from doing
the Lookup).
Does anyone have any suggestions.
FYI, the way that I know that it isn't text is when I use the
=istext() function, i get "false".
And I know that my formula is correct, because when i actually paste
the cells from the other table, the Formula produces the desired
result.
Thanks for any help! Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142180
Excel 2003 - VBA - SUMIF
Here is a tough one:
I have a table with rows of information including an ID Code. The ID code is
made up of four characters, each meaning something distinct. I want to
create a flexible reporting system where the user can specify which of these
rows to include in the report. Up to here there have been no problems,
example;
Code IMDA specifies an account that is active, indicated by the "A". Most
accounts are Active but there is also the possibility for it to be Inactive,
in which case the Code would have been IMDI, for Inactive. To gather the Net
Worth of these accounts, I simply look for the distinct code.
SUMIF(A5:A1500,"IMDA",CW5:CW1500)
SUMIF(A5:A1500,"IMDI",CW5:CW1500)
Challenge:
I would like to have the ability to use wildcards (+) in the Code to
indicate that any character in that position should be considered a match.
The above code would produce a report that has two cells showing all Active
IMD accounts (IMDA), and all Inactive (IMDI).
I would like to offer the user the ability to insert the wildcard by
changing the code to be able to handle a Pseudo Code of IMD+ where the last
character is inconsequential to a match. In the real world, this "+" could
be in any position.
Does anyone have any suggestions on how to proceed?
Craig Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142175
Re : Excel Wrap-Text with Relatively Loose Strings
Re : Excel Wrap-Text with Relatively Loose Strings
1. Enters an Excel worksheet (received from the wilderness).
2. In a fixed-width cell, there is an entry such as the following
string :-
ZSL - Postion
Indicator
HS - Hand switch / Push
Button
SS - Selector
switch
DCS - Distributed Control System SDV
- Shut down
Valve BDV -
Blow down Valve
LCP - Local control
Panel BSY -
Solenoid Valve
3. It was after discreetly manipulating the string (by adding
extraneous spaces between the given items, as shown), it rendered the
string to assemble as follows (See ?!) :-
ZSL - Postion Indicator
HS - Hand switch / Push Button
SS - Selector switch
DCS - Distributed Control System
SDV - Shut down Valve
BDV - Blow down Valve
LCP - Local control Panel
BSY - Solenoid Valve
3. Obviously, legibility of the string is at the mercy of the Cell-
width ; subsequent changes of the Cell-width will render the string
gibberish ...... and there, another repeated attempt to edit the
string by adding or deleting the superfluous spaces here and there to
rectify the situation.
4. One is indeed hapless to contemplate a correction by inserting Alt-
Enter between the given items and eliminating the spacing strings in-
situ.
5. Is there not an applicable formula to neutralize the exemplary
loose string such that the subsequent normalization of the string
would be an orderly assembly as shown above ?
6. Note that embedded in that item, Hand switch / Push Button, there
are 2 spaces located on both sides of the slash(/). And there, the
length of spacing strings would be 3 spaces and beyond.
7. Please share your experiences and recommend a solution.
8. Regards. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142173
average of a range, but only for the cells that contain values
Hello - Anyone familiar with a way to take an average of a range of
cells, but only for the cells that contain values.
So for example:
9
0
9
9
The average of the above four cells should produce an output of 9.
Thanks for any suggestions. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142170
Filter question
Hi,
I have a Pivot Table in Excel 2007 with data. I have a Date column. I need
to filter the data so it shows me the data from 01-01-2008 and today date
minus 1 day. I would like to have the data filtered automatically (without
having to go everyday manually and change the filter date).
I can see some auto filters to filter for yesterday, today, the last month,
year to date, etc. I tried the Between option but it only lets me define
dates, it doesn't let me define references to other cells or formulas (like
=today()-1 for example)...
Can anyone help me on this please?
Thanks in advance,
Elsa Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142160
test value between range, and month
I cant get the condA or condB to execute if value of A1 fall within range 1
to 10
if(and(A1 >= 1, A1 <= 10), condA, condB)
How to get the month with a increment value as below
a b c 0 mth inc
2 mth inc
1
2
3 30-may-08 =text(c3,"mmm") will get
value of "may" how to get "jul"
4 Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142159
Pivot Table Formatting
I have read past posts on Pivot Table formatting and have achieved some
success with the formatting problem.
My current problem is that on one spreadsheet I have used AutoFormat to get
the look I want for the Pivot Table. On this table I expanded the width of
the columns and the formatting has held in place. I then created a new and
separate spreadsheet file using the former one as a template. Everything
looks great, except on this file, every time I refresh, the columns go back
to the default width. I have tried enabling selection before widening the
columns with no luck.
Any help is always appreciated. I am using Excel 2002 and XP Home Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142157
Data from one sheet to another sheets
Dear Sir,
I have a ZoneWise Worksheet i;e
nz01,nz02,nz03.wz01,wz02,wz03,sz01,sz02,sz03 and so on.
Now i want to copy this data according to ZoneWise For example: nz01
in sheet1, nz02 in sheet2, wz01 in sheet 3 and so no
Thanks In Advance
Hardeep kanwar Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142154
combine sheets
Hi!
I have a workbook with 50 worksheets. And i want to combine 50 sheets
into one sheet
Is it possible?
If yes then how
Thanks in Advance
Hardeep Kanwar Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142147
The macros in this project are disabled.
From the ControlBox when clicking on the Exit Design Mode button, I
get a message:
The macros in this project are disabled.
This is preventing me from running my project.
Any Ideas ??? Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142140
General Novice Questions (Protection, Format)
I have created a spreadsheet and have restricted a row and footing row
(totals) from being changed by using the "format cells / protection"
feature. I have left all the data entry rows
unprotected so that the entry people can make changes. These entry
rows have columns with specfics formats like Date, Currency, etc and I
make it all look nice with the grid feature. Finally,
I set "Tools /Protection/ Protect sheet" to active the protected
cells.
The problem is how can the user Insert new rows?
To get around this, I created enough rows so that the user has the
space they need (50 rows) to accomodate the necessary entries. The
new problem is that if the user forgets to make any entry they have to
Insert which they cannot do because of the protection. So, to get
around this they can drag the lower existing data rows down, but then
the opening they create loses the format that I set for that column
and the nice grid I put in disappears in those rows?
Any tips?
Thanks Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142127
Insert row in Office 2007
Can someone advise me how to insert more than 1 row a time.
Thanks,
Scott Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142124
Removing filtered Blanks Cells
Hi!
How can i remove filtered blanks cells
Thanks
Hardeep kanwar Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142123
Two XLStart Directories
I seem to have two XLStart Directories:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
C:\Documents and Settings\GB\Application Data\Microsoft\Excel\XLSTART
Do I need both? I remember having some problems when I added some xla files
to one or other of those, but I can't remember how I resolved it in the end.
This is a single user machine, by the way, with only one user account
created on it. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142121
Simple formula request
From http://www.socialsecurity.gov/OACT/COLA/piaformula.html
There is this paragraph;
For an individual who first becomes eligible for old-age insurance
benefits or disability insurance benefits in 2008, or who dies in 2008
before becoming eligible for benefits, his/her PIA will be the sum of:
(a) 90 percent of the first $711 of his/her average indexed monthly
earnings, plus
(b) 32 percent of his/her average indexed monthly earnings over
$711 and through $4,288, plus
(c) 15 percent of his/her average indexed monthly earnings over $4,288.
I would like to write a single line to take the income (shown in an
adjacent cell) and produce the benefit based on this rule. I'm sure it's
simple, but I am having a brain freeze. Would someone be so kind as to
help me?
(Please forgive the duplicate post to the Mac group, this is not Mac
related, pretty generic question)
Joe
www.blog.joetaxpayer.com Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142110
Validation Criteria & Ignore Blank (cells at bottom)
Hi All,
I have a named list that has a bunch of blank cells at the bottom so
the user can grow the list as needed. The ignore blank check box in
data validation looks tempting, but I still get all the blank cells at
the bottom of my drop down list. Does anyone know how to get it so
the blank cells don't show in the list.
Worksheet called License_Only has data from C2:C210. The data is
pulled from a second file as follows:
C2 - =IF(ISBLANK([Ontario_MGS_Price_List.xls]License_Only!C2),"",
[Ontario_MGS_Price_List.xls]License_Only!C2)
C3 - =IF(ISBLANK([Ontario_MGS_Price_List.xls]License_Only!C3),"",
[Ontario_MGS_Price_List.xls]License_Only!C3)
etc. to C252. Even thought C211 to C252 are blank, I'm hoping to have
the spreadsheet still work when new licenses are added to the bottom
of the price list in these blank cells.
Defined Name called License_Only is set to =OFFSET(License_Only!$C
$2,0,0,COUNTA(License_Only!$C:$C),1)
Worksheet called Definition has the drop down cell T39 with - Data
Validation > Settings: List, Ignore Blank checked, In-cell Dropdown
checked and Source is =License_Only.
I'm trying to get T39 to not include C211 to C252 (the blank cells
from the License_Only worksheet) unless there is data in them.
Any ideas?
Thanks!
Michele Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142108
automatic backup
how do I configure Excel 2002 to create an automatic backup copy when I
create a new file or edit an existing file.
Thanking,
Ron Patterson Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142104
Dotted border that delineates pages
How do I remove a dotted border, that seems to delineate pages,
from my spread sheet? I appeared out of the blue, but probably the
result of me accidentally selecting something. Maybe during print. Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142103
Formula won't copy down the column
I am trying to copy a formula down a column. I have done it for years and
worked fine. This time, the first result appears in each cell, but if you
look at the formula in copied cells, they show the correct formula has
changed as I dragged it down the column.
So, the formula changes as I drag, but the answer stays the same as the
original cell.
The data was sent to me by someone else and I am working with it. I have
even copied just the delivered data to a new spreadsheet and the same result.
Please help Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142093
Changing a formula's result to text
I have a pretty simple worksheet that lists the date in column A.
In column B, I have a formula that converts the date in Column A to
the proper day of week.
When I put it in a pivot table, it treats column B as an individual
date, not the proper DOW.
I attempted to copy/paste special/values into a new column, but it
doesn't change it to the DOW, it leaves it as the date.
I am trying to get Excel to permanently change the cells in column B
to say "Tuesday" instead of 4/19/07.
Does that make sense? All of the conventional answers don't seem to
work for me. Any help? Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142089
Footer to list Directory & Filename
I can get the Filename to list in the foot. But, I need the Directory
information to also print. How can this be done? Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142082
Printing gridlines 2007
I have a wksht where I can see the gridlines, and have selected a checkmark
to print out with the gridlines. However, if I do a print preview or print,
the gridlines are missing in the output. I must have turned something off
accidentally.
Bob Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142081
Merge and Centre
This is my sheet
SLR NO. NAME POINTS REDEEM
POINTS TOTAL
001 HARDEEP 4500.00
2000.00 4500.00
002 HARDEEP 4500.00
2000.00 4500.00
003 JOHN 8500.00
1200.00 8500.00
004 WILLS 10500.00
5000.00 10500.00
005 WILLS 10500.00
5000.00 10500.00
006 DAVE 9500.00
4000.00 9500.00
007 DAVE 9500.00
4000.00 9500.00
And i Want like this
SLR NO. NAME POINTS REDEEM
POINTS TOTAL
001 HARDEEP 4500.00
2000.00 4500.00
003 JOHN 8500.00
1200.00
8500.00
004 WILLS 10500.00
5000.00 10500.00
006 DAVE 9500.00
4000.00 9500.00
Because this sheet has 1800 or more data some data has same and i want
to merge and centre the same data.
And after every 15 days i received this type of sheet and it is very
diffcult for me to merge and centre one by one
Any help will be appriciate
Thanks in Advance
Hardeep kanwar Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142080
updating DATEDIFF arguments in formula
Hi.
I have a column of dates, and at the bottom, I want to calculate the
number of days between the first and last dates. I' using the formula
=(DATEDIF(B6,B15,"d"))
The problem is that as I add dates, I have to edit the formula to
change B15 to the reference of the new row (e.g., B16, B17, etc.). Is
there any way to make this work like other formulas do when you add
rows? Alternatively, is there another way to accomplish this
calculation that will update automatically?
Thanks.
Rodney Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142079
Conditional colours in Lookup table
Hello,
I have a table that reports results from a lookup table.
The results are in column "L"
I am wanting specifics to be highlighted.
If a cell reports "sam" or "jim" to be blue etc.
Thanks in advance
Andrew Tag: Convert time number 9:30 to a whole number 9.5 Tag: 142078
Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
to a whole (w/fraction, or one decimal to the left)? 9.5
Re: Convert time number 9:30 to a whole number 9.5 by Ken
Ken
Tue May 13 21:15:17 CDT 2008
On May 14, 12:00 pm, "WGD" <wgd.roam...@verizon.net> wrote:
> Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
> to a whole (w/fraction, or one decimal to the left)? 9.5
>
> Thanks You!
> Wayne
Re: Convert time number 9:30 to a whole number 9.5 by T
T
Tue May 13 21:20:02 CDT 2008
Multiply by 24
A1 = 9:30 (h:mm)
=A1*24
Format as GENERAL or NUMBER
--
Biff
Microsoft Excel MVP
"WGD" <wgd.roaming@verizon.net> wrote in message
news:mJrWj.7883$Uz2.3414@trnddc06...
> Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
> to a whole (w/fraction, or one decimal to the left)? 9.5
>
> Thanks You!
> Wayne
>
>