Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Formatting

excel+training - Formatting

ResolvedVersion Standard

Wed 12 Dec 2007, 15:47 Delegate Stephen said...

Stephen has attended:
Project Intro Intermediate course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Project Advanced course
Project Intro Intermediate course

Formatting

What does * do in cell custom formattimg please?

Mon 17 Dec 2007, 12:42 Trainer Sandy said...

RE: Formatting

Hi Stephen

The * will repeat the character after the asterisk to fill up a cell to the right. (column width)

e.g. setup in Custom format

0*_

e.g. of cells with data using the format

200___________________

2000000_______________

2_____________________

Hope this helps
Sandy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel+training - Formatting

Formatting

RE: Formatting

Excel articles

Excel tip:

Using basic functions without doing formulas