|
|
Worksheet alignment is out on pc by
teddybis
I tried opening different workbooks on my PC and the alignment all seemed to 'overflow' from the A4 size setting. I had opened the same workbooks on a few...
|
|
1 |
154 |
|
|
A Turing Machine in Excel by
George W. Cherry
I'm just learning my way around Excel. I'd like to
see how to program a Turing Machine in Excel.
I Googled:
microsoft excel "turing machine"
and got over 700...
|
|
2 |
180 |
|
|
Excel Number Format Codes by
MBB
I can't figure out how to format numbers so that when you type 3220 it will look like 32.20 kinda like how you can enter numbers on an adding machine. I would...
|
|
3 |
426 |
|
|
Counting number of characters in cell by
saturnin02
Hi,
I need a formula to return in cell A2 cell A1 if cell A1 has more than just
one letter: "Bob" for example but if cell A1 only has letter "B" or is
blank, I...
|
|
4 |
507 |
|
|
Help to add Format to VBA Code! by
Bob
--
After searching Google.groups.com and finding no answer, Bob Vance asked:
Can "CopyFormat" be added to this code
Sub MonthPlus()
With...
( 1 2)
|
|
10 |
274 |
|
|
Use VBA to format cells by
emea training 2
Is it possible to use a macro to format Excel?
I have a number of sets of data under headings e.g.
Heading1
Data 1 Data 2 Data 3
Data 1 Data 2 Data...
( 1 2)
|
|
11 |
331 |
|
|
statistical analysis by
silvia restrepo
I am trying to do a correlation analysis but I have missing data, how can I deal with this, is there a way of coding missing data like a . in SAS?
|
|
1 |
275 |
|
|
timesheet formula by
David
I've set up a bi-weekly timesheet in XL2K for a two-week pay period.
D4:D17 contains the calculated time worked each day
Overtime is paid for hours worked...
|
August 3rd, 2004 12:52 AM
by David
|
2 |
388 |
|
|
|
|
3 |
136 |
|
|
pasting column and row width and heights by
Pasting column width and row heights
When I copy data where the column width and the row heights have been changed why doesn't it keep the column width and row heights?
|
|
2 |
286 |
|
|
extracting info from multiple sheets by
Jacob
I have seven sheets same setup for all seven sheets. It is a bank register,
each sheet is for a diffrent bank. I would like to get info filtered from
all...
|
|
3 |
414 |
|
|
Lookup - Formatting of numbers by
GRS
I currently have a lookup field in my spreadsheet that looks up the
price of a product by product number.
Although the lookup usually works there are...
|
|
6 |
375 |
|
|
Problem with recent Drop Down List Code by
krislyn
I recently got this code from Bob and just today tested the check boxes.
Problem is when I try to check any box beyond the first column, it will
automatically...
|
|
1 |
465 |
|
|
Margin Setting by
plumstone
I have a workbook with 21 worksheet. How can I have the same margin setting for all the worksheets? Thanks in advance.
|
|
2 |
155 |
|
|
|
|
1 |
322 |
|
|
date to day of week ignoring blank cells by
emm8080
Hi
How can I covert dates to days of week eg 30/07/04 = Fri without
converting blank cells at the end of the column.
Obviously, I can specify the column...
|
|
8 |
317 |
|
|
|
|
1 |
257 |
|
|
|
|
1 |
349 |
|
|
|
|
6 |
453 |
|
|
unhide rows adn columns by
how can i unhide rows and columns. this doenst work:
Rows("1:2000").EntireRow.AutoFit
Columns("F:H").EntireColumn.AutoFit
thanks in advance
|
|
3 |
446 |