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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

learn excel - Formatting

ResolvedVersion Standard

Thu 10 May 2007, 09:42 Delegate Eva said...

Eva has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Formatting

How to remove a dot behind an 18 digit number without corrupting it into scientific number?

Thu 10 May 2007, 13:59 Trainer Pete said...

RE: Formatting

Hi Eva, Thanks for your post; a number as large as an 18 digit number will need to be formatted to be a Number, (Format, Cells, Number - Number) with or without decimal places. If it is entered as a general number Excel will apply the scientific number value to it.

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

learn excel - Formatting

Formatting

RE: Formatting

Excel articles

Excel tip:

Autofit column width – Excel (all versions)