Can i create a new toolbar button which will format a cell in a particular
style?
I am trying to create a style similar to "Comma style" but without any
decimal places.

I am using this macro:
Option Explicit
Sub maketable2()
   Dim SheetList As Sheets

Iwant to use list,while using if function.  ie
if cell A1 = Lorry expenses i want the following in B1 and i will select any
one of the following by using function.
Fuel exp

I want to ask how to initialize a cell with a value and also I want to
perform calculation like..the previous value gets added to current value..
like I have value in cell
T6=23

I'm using the following code for an automated date stamp. Whenever dat
is found cells (AI37:IV37), the two rows above automatically insert th
day number (dd) and month (mmm), and whenever data is deleted from tha
range, the day and month are deleted.

I have a column of dates in the format YYYYMM and I want to extract a date
from this. Specifically the last day of the month mentioned
I was thinking =TEXT(MID(A22,5,2),"MMM") would return me Feb as it is
pointing at the '02' the second month. But it returns 'Jan', presumbly

I have a series of identical worksheets from First! to Last!. Is it possible
to sum the product of cell A1 and cell B1 in each of the workbooks? If so,
how? Thanks

I'm trying to devise a way to add cells within an array following a set of
criteria.
I have an array with a series of zero and non-zero numbers.  As an example:
1   0

I don't know if this is even possible, but, chances are that it is! I have
three columns, (1) = "A" has currency values set as income, then, column (2)
= "C" has a set of currency vals that are 8% of values in column "A". Then
columns (3) = "E" also has currency values which are ...

How can I get rid of the dreaded #value! error message if there are blank
cells involved in the calculations?

Here's the calculation generating the error, how to get rid of it, if there
are zero or blank cells in the calculations?
=IF(F32="","",$D$34*F32)

I am using a web-based software that reports the date and time a record was
captured.  I can export these records to Excel.  I would like to convert that
date/time to HK time (GMT+7).  I have been able to convert the time, but not
the date (date frequently changes).

I'm using NETWORKDAYS in a scheduling spreadsheet to calculate the
number of working days between two date columns.  The first column (C)
records the date a task was created, the second (E) when the task is
scheduled to be completed.  If the lead time (the difference between

I have a 120x120 matrix of five digit numbers like so:
52000    42222    43213    01016
52020    42200    43202    01000
52000    42202    43103    01016

I have a range of cells that may or may not have a currency figure in them if
a cell in the range has currency figure I want the figure placed into another
cell, ie. A column has an expenses listed and then they need to be itemized
below.  Isthere an IF function which will do ...