|
|
Formatting Dates in excel by
Keoni2008
I have about 2000 rows (x4 in columns) of dates in 2 formats and they are
"0/00/00 and 00/00/0000". How can I quick fix this problem into just one
format...
|
|
3 |
405 |
|
|
|
|
1 |
470 |
|
|
MS Excel 2007 "Recent" files not updating by
John Gee[_2_]
When I go to the Start button, then click on Excel 2007, a window opens
showing Recent files. For whatever reason, these are not being kept recent,
but are...
|
|
1 |
405 |
|
|
|
|
3 |
378 |
|
|
formatted colored text by
Brenda
When I format text and/or numbers to be in color, it continues to show as
black and white on the screen. What am I doing wrong?
|
|
1 |
376 |
|
|
If statment by
Cerealkiller via OfficeKB.com
If g44 equals 0 then h44 it is returning it as false maybe i am missing
something
=IF(G44=0,H44)
--
Message posted via http://www.officekb.com
|
|
5 |
288 |
|
|
export data between excel files by
scott
how do setup an excel file that each time when I enter data it will export to
another excel file in the same column of subsequent rows? Thanks. Scott
|
|
1 |
464 |
|
|
TIME SHEETS by
puzzled
I am trying to design a template to do timesheets with. How do I create a
formula that will read in time, out time, lunch time then total for the week?
...
|
|
1 |
449 |
|
|
printing selection by
Anniel
I want to print a selection. I select the proper cells, but there is an
extra row that prints at the top. It is always the same row, so perhaps I
have it...
|
|
2 |
251 |
|
|
|
|
2 |
377 |
|
|
combine formulas into 1 by
DebC
In the examples below, is it possible to combine the 2 formulas into one?
I need to simplify my spreadsheet if...
|
|
1 |
306 |
|
|
Addition function of multiple cells by
DB74
Does anyone know if there is a function that will take a list of numbers in
different cells and run various addition combinations on the list to detemine...
|
|
9 |
483 |
|
|
If statment problem by
Cerealkiller via OfficeKB.com
I have Excel 2000 I am trying to make this IF statement work. What I want to
do is if H44 equals a number 1 to whatever then use colum N44 if H44 equals 0
then...
|
|
5 |
299 |
|
|
|
|
3 |
300 |
|
|
|
|
1 |
276 |
|
|
Booked locked for editing properties by
RFW
How do you set the properties so that whoever is in a workbook and you get
the message "...locked for edtiting" Isn't there a way that each person from
their...
|
|
1 |
288 |
|
|
Matching pairs of Data in cell by
whatzzup
Good day, i would like a solution to this problem. i have a set of data in a
spreadsheet, these could be repeated, what i would like to display pairs of...
|
|
1 |
293 |
|
|
|
|
1 |
342 |
|
|
Text to Column will not cooperate by
Going Crazy with excel[_2_]
Looking to separate two names in a cell, separated by a Hyphen.
It will not separate the names.
Is there a formula that will work to separate them?
Example:
...
|
|
2 |
375 |
|
|
links not working HELP HELP HELP by
Michele
In our office we use copy links in Excel and special paste them into Word
documents and we are having great difficulty updating our links when we open
our...
|
|
1 |
304 |