Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting Cells
Resolved · Low Priority · Version 2003
Antonia has attended:
Excel Intermediate course
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?
Hi Antonia
Thank you for your question and welcome to the forum.
Do the sort codes you are entering contain any zeros?
Amanda
Hi Amanda,
Thank you for your response.
No, they do not contain any zeroes.
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 ExcelYou can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this: |
We'll call during UK business hours
Server loaded in 0.08 secs.