When I enter number "2000." I get 20.00 - yes, set decimals at 2 but earlier
excel would accept change if you entered decimal with number.  this is
slowing down a budget prep and I'd sure like some help - online and tutorials
say "enter decimal" but this is not working.  what am ...

Hi is there any way to get current exchange rate into cell in Excell ?
I do this every day so would be great to automate such a thing.
regards
Piotr

New to VBA, I'm struggling to do the following:-
For each row (y) starting at row 5 (say)
  If the intersection of the row and column AT (say) has a value "X"
   Then, in that row, for each cell with no content, change the

  Anyone know how or if I could create a text scrolling window withing a
cell or a small group of cells?  The purpose of the text scrolling window is
that if there is a lot of text, it would not cause the cell to expand or for
the text to be hidden.  I could simply scroll ...

How would I write VBA to retrieve (get at) the value in a cell byte by
byte from its natural form? i.e. no conversions are to be performed.
E.g., if a string, then I may get more bytes than for a number.
Thanks.

I keep my sales pipeline in Excel XP, and have used a pivot table to
summarize the data.
I have a field (column) in my data called "Pipeline Status".  Values in that
field can be "Sold", "Proposed", "Lead", or "Dead".

i feel like a complete idiot,, it has been some time since ive used exel, but
i swear that i remember that this worked... i have a column of numbers that
ive autosummed,, why doesnt the autosum change when i change one or any of
the numbers in that column?

I would like to extract a range of records using 'advanced filter'
The range I would like to extract would be based on a numerical value ...
and the criteria is:
 'Greater than or equal to'  AND "Less than or equal to"

I backed up my files to floppy disks and then clean installed Windows 2000
over Win 98.  The first two excel files on this disk will not open.
I get an error message "<filename> cannot be accessed.  The file may be
reado-only, or you may be trying to access a read-only location.  ...

Is there a method to display an image file in a cell (or cell range)
conditional on the selection from a drop down box?
For instance, to select a colour from the list, and have the colour
displayed in the column adjacent (as in colour swatches from a paint store,

In my spreadsheet, a square is showing in the currency amount rather than a
period. For instance, if I need to have
$400,000.00 in the cell, it gives me $400,000Square00 in the cell. I can’t
draw a square from the keyboard here, so I typed in the word SQUARE here

Excel begins to load(I see my name below logo), but then closes with
'Microsoft Excel has encountered a problem and needs to close'.I can,
however, open Excel only in Safe Mode but only in the Administrator log-in,
not my

   Sorry about all these post :( but i think i am nearly at the end ...
   I have now created a tool bar with some buttons and dropdown menu. I did
this in 2003. I have attached the toolbar to the workbook but when I tried
to give this file to another use ... There is nothing on ...

I'm trying to shade cells in an Excel sheet.  However, there are only a few
colors to choose from and they're all quite dark/unattractive.  How do I get
more customized colors?  I see it is possible to "mix" by using patterns, but
that's quite clumsy I think.  Are there any other ...

Is there any way to control the size of the text in a list controlled
validation drop down box?  I have quite a long list to shown and my text is
microscopic.  I've searched the group and didn't see anything.
TIA