[bluejeans333]

I've tried copying/pasting into Notepad; formatting cells into every format possible; have tried making another column, entering the =VALUE(A1) formula, and copying/pasting down the column; have tried Text to Columns; and find/replace $ sign...

When I export my data into Excel, I am unable to sort correctly and therefore, am also unable to Autosum.

Sorting results in:
$1,000.00
$110.00
$12.00
$50.00

Instead of by true value:
$12.00
$50.00
$110.00
$1,000.00

Please help! thanks in advance

*note, attached doc is just a sampling of the several hundred records from the exported report
Excel 2003, Windows xp

[nesr]

Peace be upon you
1- please apply this function =VALUE(TRIM(MID(B1,2,LEN(B1)-2)))
2- Pull down to all your values
3- mark Solved
Thank you and best regards

[JohnWilson]

Make sure non of the selected cells ae selected

Do a replace $ in Find What nothing in replace > Replace All
Do a second replace in Find What Hold down ALT and type 0160 on the numeric key pad (non breaking space) nothing in replace what . Replace All

Now sort

If you do not have a numeric key pad on a laptop you can select a value and you should be able to select and copy the nbs at the end of the value in the formula bar and paste in into find what

[slurpee55]

More simply, enter this into column C:
=LEN(B1)
and drag all the way down. Then highlight both columns, go to Data, Sort, and sort by column C first and then by column B.