Mac Forum / Applications / Excel / October 2006

I am trying to produce a time sheet program such that when I enter the
letter 'x' in a specific cell I can record that time as my start time
in an adjacent cell.  Then by inserting an 'X' in the next cell I can
record my finish time and so on. I can capture the time with an "if

I have a problem which I cannot figure out.
I have a table like this:
a 1.6
b 1.5, 1.6

I am not using Excel, sorry dont know where to post. But I hope someone will
help me anyway.  I would like to create a spreadsheet with multiple tabs (one
for each month) in a master spreadsheet.  I cant figure it out, I have seen
it done...is it possible, if so can you help me??

I found the following macro but it doesn't seem to run:
Public Sub RemoveTrailingSpacesAndFullStops()
        Dim rCell As Range
        Dim sTemp As String

Hey folks,
My company's invoicing program outputs data to an Excel spreadsheet
with the following header row:
Line Item Type, Customer Name, Invoice #, Invoice Date, Amount

Morning
How can I increment numbers in brackets or with dot and bracket in each
cell of a column?
 1.) | (1103)

I love Excel and used to consider myself on the more intermediate to advanced
end of knowledge however this question is now making me feel like a beginner.
I am currently running Office XP 2002 and I need help....
I've been quering in the forum and see a whole bunch of answers ...

My friend has a couple excel files include internet query data. She
asked my help. Yes we can refresh them but can not create them on her
Mac. Where is our mistake ? Mac Office is different in this ?

I have several Excel spreadsheets with columns of dates. They are
formatted with an apostrophe and then the two digit year. ex: '00.
When I paste the document into InDesign the apostrophes dissapear. I've
tried changing the font to Times Roman with no luck. I am using

I am using some software, called WebFOCUS, that outputs an Excel file
in a
Web Archive file format (.mht or .xht). They can have many tabs across
the Excel file and

If I insert (or even ³Copy Image²) of a portion of an Excel spreadsheet into
a Powerpoint slide, my Windows (2000) colleagues don¹t get the accented
characters (instead they see a ³tild² character (~) or other strange
characters). The Font used is Arial; should not cause any problem ...

Does anyone know why Formatcurrency in VBA for Excel 2000 on a PC can
work just fine, but in VBA for  Excel 2004 on a MAC is a problem?

Hello, I would like to know how to link cells between worksheets.  For
example, I have 5 sheets within a workbook.  I would like to link cell
"b10" on sheet 3 with cell "b16" on sheet 5 so that whenever I change
the data in one cell, the other automatically changes.  Even if I erase

The short story: does excel have any function that can tell me whether
a value is between two other values?
It seems like this is a pretty basic one (easy to do from a programming
point of view) as well as very useful, so I'm surprised that excep

Excel 2000
I have created an excel spreadsheet with dropdown lists, formulae etc. and I
have locked these particular cells and unlocked the rest.  When I protect the
sheet it allows me to type in the unlocked cells, but will not allow me to