Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formats

ResolvedVersion 2007

Lisa has attended:
Excel Introduction course
Excel Intermediate course

Formats

How can I find formatting sections?

RE: Formats

Hi Lisa

Thank you for your question.

Could you clarify your requirements for me please. In particular.

1. Do you want to alter the formats for specified ranges?
2. Do you want to find cells with specified formats
3. Do you want the formats in a cell to change depending on its value?

Regards

Stephen

RE: Formats

1. Do you want to alter the formats for specified ranges?

I need to understand them first.

2. Do you want to find cells with specified formats

Yes I tink thats the term, I want to understand what I do to find formats and how I find the glossary and language of the formatting.

I have just implemented an excel sheet at work for my stamps, we dont have a budget but I have a few columns and rows incorporating amt of stamps, total they cost, along with who spends what amt per day (if any) on stamps, and I would like to monitor and combine the value of the stamps to go down with the total, therefore I can see how much I have in stamps and cash.


3. Do you want the formats in a cell to change depending on its value?


I need to understand them first. How do i find out what they mean?

RE: Formats

Dear Lisa

Thank you for attending Excel courses!! I hope you enjoyed the courses and benefited from them.

Further to my colleagues request would you please elaborate your query? Do you want to use the Format as Table feature that allows you to manipulate data easily and efficiently?

Kindest Regards


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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.