internal coding

A

apples

for my project, i have to add the lawfirms old unpaid invoices into m
spreadsheet. this was a multiday project, and somewhere along th
line, the coding of the numbers changed so that excel is treating the
like numbers instead of text. i went to the formatting, and nothin
has changed there. the problem is that when i add new invoices an
want to sort the list A-Z, the newly entered invoices are automaticall
thrown to the top of the list regardless of where they should be sorte
to. its as if their values supercede that of the other invoices...

has anyone else encountered this problem and do they know how to fix i
 
F

Frank Stone

hi,
It's formating. look at the old invoices(the ones you
didn't enter) and see if the number has an apostrophe (')
in front of the number. This number would be recognized as
text and would be sorted to the bottom.
if this is the case, you can add the apostrophe to the
invoice numbers you added with the following formula
=left("'" & A1, 8)
where a1 is the cell adress of the invoice number you wish
to change and 8 is the number of characters in the invoice
number + the apostrophe.
regards
Frank
 
Top