Question about Microsoft Office 2003 Pro (269-07387) for PC

1 Answer

Excel 2003 I created a spread sheet that our compamy uses to list employee hours on they print their sheet and i then do my work from it.What I need to know is how can I put the Day and the Date in the header in the column on the right side of the page so that it will update each day. I can put in the date using ( &[date] ) But I cannot seen to get the Day of the week in the header.anything you can offer I will try.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 214 Answers

Put in the function TODAY and format the cell with Date = Wednesday, 25th April, 2008 (format)

Posted on Apr 25, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Print is misaligned when printing avery stock


Dear friend,
If you are using Excel or other spread sheet, you shouldn't print in draft mode. You'll need to use Normal or higher definition.

Regards.

Oct 13, 2011 | HP Photosmart C4480 All-In-One InkJet...

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

1 Answer

How do you print envelopes?


More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

How to sende information from a sheet to another?


You can link to the original sheet or copy and paste - Linking might be easier as you only have 10. - Can you not use worksheets rather than excel. If you want to make it more autonomous you can index or look up the first sheet so any changes you make will be reflected back in your employee sheets.

May 26, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I have printer HP PSC 500 S/N SGH02E112T WORKED FOR 5 YRS - NOW WILL NOT PRINT EXCEL SPREAD SHEETS OR WORD DOCUMENTS - STILL PRINTS EMAIL AND INTERNET DOCUMENTS HAVE HAD OTHERS CHECK SETTINGS...


Friend,

There's apparently a problem bwtween your Office suite and the spooler. Usually uninstalling/reinstalling the Office suite will fix the problem. (please do a backup of all your Office documents before proceeding!)

When reinstalling, please make sure that any antivirus program is shut down or deactivated during install, in some cases for example Norton Antivirus will block files that need to be updated, causing problems. You SHOULD use some form of virus protection when using your computer, don't get me wrong! :)

//Al

Mar 08, 2009 | HP PSC 1210 All-In-One InkJet Printer

2 Answers

Excel oquestion


how to remove the excel file security pass word


solution explain tel plz

Feb 09, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Sharing Problem


some colors are not available in office 2003

under (office 2007) excel options (alt-t-o), save tab, you can choose which colors will be seen in previous excel versions.

Sep 23, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Office 2003 Pro (269-07387) for PC Logo

81 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...