I have a column in Excel that has words in it like the following:
Employee ID Format
Company Options
Processing Schedule

Does anyone know anything about formatting cells so they would behave
like an accounting calculator.  As in typing "12345" without pressing
any decimal key, and have it use the last two digits as the tenth and
hundredth decimal place, ie) "123.45"?

Is there a way for an Excel function to query a DNS server?
Thanks.
Soundy

I'm really new to excel and this forum, so please bear with me...
What I'm looking to do, is having one "week-sheet" and one sheet for
every workday, and having each of them updated with their correspondent
dates.

Sorry for this very basic question:
what is the max capacity for data points (in cells, by row and column
of an excel spreadsheet?
any help on this would be greatly appreciated.

Hiya,
My sister created a password on an excel spreadsheet that is very important
2 me, and she cant remember it, now I can only read the sheet and I can't
modify it.

i need to convert dates dd/mm/yyyy to decimal years yy.yyyy but cannot
find an example of how this can be done.  i would be grateful for
help?
thanks

Gang,
I've got a simple X*Y chart with year (1977-present) on the x-axis and
an estimate of deer population size on the y-axis (actually, there may
ultimately be 2 estimates/series).  There is nothing really all that

Gang,
Some time back I posted to the group my frustration with complex cell
formulas.  Many in the group helped with ideas.  I'm writing this note
because I still think there must be a better way.  Below is my latest

I have an expenses sheet set up as follows:
   A/status                B/date          C/expense type       D/amount
1  allowed               05/07/06             car                     £20.00
2  notallowed          05/07/06             car                     £450.00  

I have a spreadsheet in Excel 2003, which has approximately 600
records (or rows).
There are a number of values for each record, such as elecment code
description and group.

I have a workbook that has a load of pivot tables in it.  When I share the
workbook I can't use the pivot tables anymore.  Please would someone tell me
why, and how do I get around this.  I need to be able to share this
spreadsheet so that other users can make use of the pivot ...

I have excel 2000, and have locked some cells on sheets to safeguard my
formulas whilst others are unlocked as they have weekly figures put in up
until Sunday. On Monday, a clean sheets starts again so I have to go and
delete all the entries on all the unlocked cells.

I'm trying to make a little sheet that counts for example points /
hour.
I calculate spent time as "ending time - starting time". And now when
I'm trying to divide my "points" with this with time spent excel gives

I need to burn some files ( Word,PPTs,PDFs, etc) onto a CD.
These are referenced using hyperlinks in excel.
Is there a way to maintain the hyperlink while burning the CD, so that
the hypelinks still work while on the the CD ??