I have a spreadsheet with the following information:
Cell I6 is blank until a session has been completed, at which time the
trainer will enter the date of the session.
Cell J6 is a vlookup that will tell me the # of calls taken on the date that

I wanted to know how can one display the result of a calculation as a text
insteas of a number.
e.g 2+2= 4 - how does one get the output , 2+2=four
pls help,

I have looked at previousr messages but have been confused. I want to change
the default comment that my worksheet uses. Help please.

Some of our ratios calculate as times, such as some turnover ratios.  How can
we make them display with a small x in front of the value?

Anyway to use the above functions to, say,
work every other nth cell in a row or column?
Say I just want to process A1, A4, A7, etc.
(every 3rd cell, n=3), or maybe A1, A3, A5, etc.

I believe there is a way to set up a cell so that I can have text and a
formula in the same cell.
For example, I want to have a cell say "for the period ended (ref)".   and
the reference would be to another cell on the worksheet.

I am attempting to remove any leading spaces should there be any within a
range of cells
Example:
In Cell B16       "  find the spaces"

I have a database which depending on the criteria increases or decreases in
length. What I am trying to do is find the Max/Min/Median % in one column of
data of varying size, e.g. if I select criteria 1, the data length is 100
rows, if I select 2, the data length is 25 - data is ...

Given the table below. In column C, D etc I want to get the result of how
frequent a certain port is mentioned.
    A    B
1

I have written the following formula
=IF(K11<=0,"Passed Live Date",IF(AND(K11<=7,K11>=1),"Within One
Week",IF(AND(K11<=14,K11>=8),"Within Two Weeks",IF(K11>=15,"Over Two
Weeks"))))

I'd like to write an error notice for our time sheets.  I'd like to warn the
user that if
A1>24, then he needs to use A1-24 hours of leave which otherwise will be lost.
Thanks in advance,

I'm trying to create a formula that will tell me where the last
occurance of #N/A occurs in a table. If I have,
1         2        3         4     5
#N/A   #N/A   #N/A   2%   8%

I have a lookup which produced 200 matches (180 unmatched).eg
G_100-01_LS         Match
G_101-01_LS         Match
G_102-01_LS         Match

I'm having difficulties setting up DV, using the Custom Formula, to
display the error message "Not a pay day" if the user enters a date
that's not a pay day.
Pay days are ....

I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?