Need simple formula for finding 30% of a number

I set the date format with regional settings "Italy" how ever I still have to
enter date as mm/dd/yy  while we are used to write it dd/mm/yy.
Did I did the wrong settings, even if I tried sevral european ones, or is
there something else to do so that I could finally insert a date ...

Hi. I was browsing the topics in the forum and most of the things I found are
deleting duplicates involve entire rows. My problem is this, I need to delete
duplicate records by row.  For instance, in my example below, I want to
elimate the duplicate "20" under column C so that ...

I am working in excel and need to have a warning when information previously
keyed is being duplicated in the same colums.  Example:  column B is always
ticket numbers.  I want excel to warn me if while keying in column B I key
the same number in a different cell.  I want this ...

I have created a database in excel 2000. To gather the data from the database
l have used the template wizard. I need to load the database onto my computer
at home which is windows XP. I can open the database from my memory stick but
my list and combo boxes are not displaying. ...

The autofilter indicators (the little black or blue triangles) are difficult
to tell the difference between unfiltered (black) or filtered (blue).  Can I
change the default color for the filtered columns to something more
distinctive than the blue color?

I can not easily differentiate between the black unfiltered columns and the
blue filtered one/s.
Is it possible to change the arrow on the filtered column to a different
colour?

Is there any short cut to copy just above cell to its bellow cell?

There was a command, protecting cells from unwated edit.
I thought it is in options or cells, but I couldn't find.
Do you where is it?

It is my understanding that cell references, by default, are set up to be all
relative.  Somehow I've changed my defaults to have my cell references all be
absolute.  What menu setting do I have to change to get the default back to
relative?

Is there anyway to do one footer and header and have it apply to the entire
workbook.  I have 70 sheets I'd like to add the filename, tab and date but
didn't want to have to go into all 70 worksheets to add.  I've tried in print
view for the workbook but it only did the sheet it ...

My computer suddenly restarted while a word document and excel sheet were
open and office was set to autosave every 2 minutes so i didnt lose my work,
I found the autosave file for word but there wasnt one for excel. will excel
autosave? and how can i set it up that it will?

When i go into options and change the default file location to the "F" drive
for my storage area, it won't let me do this... What am I doing wrong?

When you choose "find" in msexcel 2003, you can choose options, and change
from the default "within sheet" to "within workbook".  Can you modify excel
to have the default option to be to search w/n workbook?

HOW TO CHANGE THE VALUE IN STATUS BAR?