I have to conevert a column of data in excel from degrees minute seconds
(DMS) to decimal degree.. And excel only accepts data in form of dd mm ss and
my data is in format ddmmss.. theres just too much data to do it manually..  
Can anyone help me find any function which allows to ...

Setting up a data entry screen with 9 columns. The first 3 columns (Entry
date, salesman, customer) might repeat several times: How do I repeat and
display the value from the cell above if there is no value entered in the
current cell?

I have 4 columns : A1 is date; B1 is Advance; C1 is Deposit and D1 is
Total...
How do I do this formula so that D1 shows the total. The total column will
be in a negative because the Advances are more than the Deposits but I think

Hi Experts
I have recently inherited a problem with file locking. the problem is
inconsistent, but most of the time when I close a file and try to reopen it
or when I exit excel and then try to reopen the file I get the "File Locked

I have a large table in an Access project (.adp), one field of which is
a 20-character alpha-numeric code, where each character signifies something.
The code may contain internal spaces i.e ABCDEFGHIJ  12345678
where char's 11 and 12 are spaces.

Can anyone provide some assistance?
Thank you

I am trying to find a formula that allows me to know how many days an
employee took as a vactaion on each month a summary sheet for each
employee
In order to find the number of days taken i have use the following :

I've got a column with duplicate records. I want to be able to pull
records that has the most duplicate. For example, on the column, I've
got 3245,3546,3245,5467,3245. Since 3245 is a duplicate, I want to be
able to pull all the duplicates. To go further, is there a way to

I am trying to copy a formula down a column.  When I copy the formula down I
want the cell to be blank until i fill out the cells to give me my balance.
My three columns are
Debit / credit / balance.  My formual reads :  f7(balance column)+e8(credit

I am trying to make a chart using the XY Scatter line graph, i.e. smooth
connected line.  I want my X axis to show the actual numbers, 83.3,
86.7,91.7 etc. However, the numbers showing are in units of 10s.  What do I
have to do to change the X axis to show the actual numbers?

I often produce medium sized tables in excel where numbers with a
value of less than 5 need to be suppressed, that is changed to a "-"
symbol. I could make a copy of the table and use an if formula to to
get the desired results, but this seems cumbersome. Is there anyway to

I have dates like 29 March to 5 May how do i calculate the number of days

How to create a Drop-down list in cell A1 with a values from cells B1:B100?
Thanks in advance!

I think sumproduct is the right thing to use - but i need help!
I have a row of columns in which "TOTAL TO FEE" appears a number of times.
What i want to do is sum the value of each cell in a row which has the
column heading "TOTAL TO FEE".

I'm Paste Special/Linking formatted dates (dddd, mmmm dd, yyyy) and text
values in a calendar type list - linking to a copy of the calendar. When I
don't have any dates or values on specific lines, I want the copy calendar
to have blank lines. However, because I format the date I ...