|
|
Format Number by
Becky
I have numbers that import into Excel and they come in
with the General format.
Example: 34350
The number is actually the amount of a check for $343.50
I...
|
June 30th, 2004 08:37 PM
by Becky
|
2 |
527 |
|
|
|
June 30th, 2004 09:42 PM
by jeff
|
1 |
407 |
|
|
Currency Symbol Problem - Costa Rican Colon by
SteveT
When I attempt to format my column of numbers using the
format cell, currency feature , I select Spanish Costa
Rican Colon which shows in the drop down box as...
|
June 30th, 2004 09:50 PM
by SteveT
|
0 |
687 |
|
|
Excel formula question - nested VLOOKUP? by
brightshadow
So far, I have a VLOOKUP function that searches another sheet and pulls
the data from a cell matching a name located in row 4 of the same
column, and converts...
|
June 30th, 2004 10:12 PM
by AlfD
|
4 |
271 |
|
|
Can you create Conditional Validation Lists? by
shadestreet
I apologize for the blank post, I have been having problems accessing
this site through exceltip.com....keeps saying the forums are under
construction.
In any...
|
June 30th, 2004 11:30 PM
by AlfD
|
2 |
388 |
|
|
Square Character in Excel (apostrophe) by
Robmo
In coverting and copying data from the Internet into excel, we constantly have square characters appear in a number of places, but in particular in place of...
|
|
3 |
302 |
|
|
new book saving & gridline colours by
FJDx
When I open Excel, a new workbook appears called "Book1.xls". On my home
computer, I can go on to close Excel down without it asking me to save
Book1. However,...
|
|
2 |
285 |
|
|
Macro help please: Excel data to word doc by
anna-maria
Hello,
I've read through all of the other posts regarding this matter and it's still not working. Here's my situation:
I have created an excel file in which...
|
June 30th, 2004 11:53 PM
by AlfD
|
5 |
1,623 |
|
|
combo box by
alekm
Hi,
how can I put combo box on sheet from which user can pick appropirate month?
Thanx
alekm
|
|
4 |
201 |
|
|
Combo-box with Choose formula by
Abdul
i am using choose formula with combo box. On the basis of "Cell Link" i
am retriving the figures shown just against the combo box list e.g
abc 100
def ...
|
|
1 |
180 |
|
|
Macro to hide rows by
markstro
I have a certified payroll spreadsheet in which I want to display only
the employees that have pay data entered that week.
I often unhide all rows, enter data,...
( 1 2)
|
|
14 |
1,108 |
|
|
getting macros to work in all workbooks by
andy
i have a workbook that i use as a template. i am using the save as option in order not to change any of the data on it. However, whenever i save it under a...
|
|
1 |
201 |
|
|
Strange Tab Key Behavior by
bg18461
I have a userform with about 20-30 textboxes. When users use the tab
key to navigate, it will work, then all of a sudden just stop. The tab
stays inside the...
|
|
1 |
356 |
|
|
Expanding Data As Needed by
MT
I am wondering if there is a way to automatically expand a list of data that varys with clients, as needed. For instance, I have an Input Worksheet, where all...
|
|
2 |
628 |
|
|
PageSetup macro calls are slow by
Stan
The code below takes nearly 11 seconds to run; this is on a WinXP with
a P4 at 1.2 GHz, 512MB RAM, oceans of free disk space, and Excel 2002.
Experiments with...
|
|
1 |
245 |
|
|
COMPILE ERROR message by
J. J. Levin
I've just installed Excel 2000 on my computer, overwriting my old Excel 95, and
now every time I access the program (or go to shut it down) I get the...
|
|
4 |
225 |
|
|
|
|
3 |
693 |
|
|
Merge and Center Problems by
Lynn
Has anyone experienced problems with the Merge and Center
feature in Excel? If so...what are they? I was told to
avoid this feature because it interferes with...
|
|
2 |
547 |
|
|
|
|
1 |
409 |
|
|
Macro Question by
Scottmk
Hello everyone,
I have the following Code in Excel:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address "$G$4" Then Exit...
|
|
1 |
202 |