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 » Formatting Cells

Formatting Cells

ResolvedVersion 2003

Wed 1 Oct 2008, 16:49 Delegate Antonia said...

Antonia has attended:
Excel Intermediate course

Formatting Cells

For some reason when I used custom to format a cell with "sort code "xx-xx-xx the cell formatted my data with sort code -11-11 and skipped the first 2 numbers... what do I do?

Fri 3 Oct 2008, 17:02 Trainer Amanda said...

RE: Formatting Cells

Hi Antonia

Thank you for your question and welcome to the forum.

Do the sort codes you are entering contain any zeros?

Amanda

Fri 3 Oct 2008, 17:04 Delegate Antonia said...

RE: Formatting Cells

Hi Amanda,

Thank you for your response.

No, they do not contain any zeroes.

Mon 6 Oct 2008, 09:55 Trainer Amanda said...

RE: Formatting Cells

Hi Antonia

Try setting ##-##-## as the custom number format for the cells you are entering the sort code into.

Amanda

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy