|
|
Leading Zeroes by
alex robkin
if you create the csv file with ="00300",This will display initial zeros!!!
include the equal signs surrounded by quotes....
|
|
5 |
1,396 |
|
|
how to make a budget by
spazpup02
:( My husband owns a propane business and wants me to build a budget for
our customers. Can anyone tell me how to go about doing this?? I was
told Excel...
|
April 26th, 2004 09:53 PM
by gls858
|
1 |
1,387 |
|
|
Insert Picture from dropdown selection by
Mike at Channel
I'm working at a Marina and trying to make a comparison chart for different
types of boats. I am trying to make a list, and based upon the users
selection of a...
( 1 2 3)
|
March 22nd, 2006 01:14 AM
by CLR
|
21 |
1,374 |
|
|
Stripping and Conversion. by
Rodney
Here is what I hope to be a fair sample of some prices in a column,
is anyone able to offer a formula to strip the text
and convert to decimals...
( 1 2 3)
|
June 27th, 2005 05:51 AM
by Max
|
28 |
1,367 |
|
|
|
|
1 |
1,348 |
|
|
add sheets by
-----Original Message-----
ho do i add more sheets to the "CURRENT" workbook,, not
new workbook
.
Click first on Insert then click worksheet.
BEST...
|
April 26th, 2004 03:25 AM
by
|
0 |
1,341 |
|
|
|
October 27th, 2005 03:06 AM
by MEGTOM
|
5 |
1,300 |
|
|
strange recurring problem by
steven
When I save a file in Excel or for that matter Word, I am
unable to open the file(s). I get a prompt saying that 'my
virus scanner has detected a problem with...
|
|
1 |
1,286 |
|
|
Lock group of rows for printing purposes by
Benjamin
I'm setting up a grid with client names, addresses, phone numbers, etc. Some of the information for each client takes up two rows, others three or four. If I...
|
|
2 |
1,270 |
|
|
|
|
0 |
1,264 |
|
|
|
|
2 |
1,264 |
|
|
|
June 22nd, 2004 06:45 PM
by Trevor
|
1 |
1,222 |
|
|
field highlight by
djranks
i have an account spreadsheet. with a column heading reading status.
How can i tell excel to highlight all cells containing status "I" for
inactive in red, and...
|
|
3 |
1,219 |
|
|
need to learn it all... quickly! by
ziploc_chik
I've got a job interview for an office administration position in a week's
time. I've said that I'm familiar with all Microsoft Office applications
which is...
( 1 2 3)
|
|
22 |
1,215 |
|
|
Seeking Improvement on excel function by
wilchong via OfficeKB.com
Dear sir,
I have one question regarding an "index" formular together with "match". I
used to set the following excel function to pick the data from the...
( 1 2 3)
|
|
27 |
1,208 |
|
|
creating a resource appendix by
Trainee
Hi, I'm trying to create an appendix for a lot of resource
information. Having trouble with the text and alligning
the columns. Also, I want the grid lines to...
|
|
1 |
1,208 |
|
|
scroll function speed by
David McRitchie
Hi Carrera,
Try holding the shift key while dragging the scroll bar, it will be
more consistent in speed.
Another way to get to a location is to type the...
|
|
0 |
1,197 |
|
|
Merging Cells by
David
Hi
I have a list of a couple of thousand postcodes in a column in a
spreadsheet. Each postcode occupies its own cell. Examples of each postcode
might be...
( 1 2 3)
|
September 2nd, 2006 08:36 PM
by SteveW
|
24 |
1,195 |
|
|
|
March 21st, 2010 09:21 PM
by Catalog
|
1 |
1,179 |
|
|
rounding by
tjtjjtjt
If you are always rounding down, you might check FLOOR as well. It's syntax is, in my opinion, easier to work with than ROUNDDOWN.
tj
|
|
0 |
1,178 |