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 » Cell format

Cell format

ResolvedVersion Standard

Wed 26 Mar 2008, 17:00 Delegate Kristina said...

Kristina has attended:
Excel Introduction course

Cell format

When using a dash in a number; eg 12-3, the cell will automatically change this to a date eg 12-march. Changing the cell format to general or number does not rectify this. Does this mean it is not possible to have a number such as 12-3 in a spreadsheet?

Wed 26 Mar 2008, 20:34 Trainer Rich said...

RE: Cell format

Hello

Before you type the number, set the format of the cell to be text. The dash is the problem here because as soon as you put this in excel will no longer recognise it as a number. you have to use text

regards
rich

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Cell format

Cell format

RE: Cell format

Excel articles

Excel tip:

Using an equal (=) sign that isn't part of a formula