Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007

Excel 2007

ResolvedVersion 2007

Thu 26 Jun 2008, 16:28 Delegate Dalila said...

Dalila has attended:
Excel Intermediate course
Excel Advanced course
Word Advanced course
Word Intermediate course

Excel 2007

workbook interlinked- how to delete lines without formula switching in between lines

Mon 7 Jul 2008, 06:57 Trainer Rajeev said...

RE: excel 2007 - Workbook Link

Dear Dalila

Thank you for attending Excel 2007 Intermediate. I hope you enjoyed teh course and found it to be beneficial!

Your question is not very clear to me. Can I please request you to provide me an example of what you are asking so that I can be clear in answering your query.

many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Excel 2007

Excel 2007

RE: excel 2007 - Workbook Link

Excel articles

Excel tip:

Formst Excel to display leading zeroes