formatting cells

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting Cells

Formatting Cells

resolvedResolved · Low Priority · Version 2003

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?

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

RE: Formatting Cells

Hi Amanda,

Thank you for your response.

No, they do not contain any zeroes.

RE: Formatting Cells

Hi Antonia

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

Amanda


 

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips


Server loaded in 0.08 secs.