Currency format in sort

[Ricki Miles]

I am working in Excel 2003. I have numeric data in column A that gets
sorted. I would always like currency format in the first cell (A2) under
the heading in A1. If I apply the format to A2, but then sort, the number
with the currency format from A2 moves around and the new number in A2 no
longer has currency formatting. Is there a way to lock in the format for
cell A2 and still be able to sort? I don't want to have a separate column
for the dollar sign.

Thanks,

Ricki

 

[Dave Peterson]

I couldn't do it.

But if you do this a lot, maybe you could record a macro when you:
select your data
sort by the column(s) you want
format that column to General
and finally format that single cell the way you want.

===
Or maybe change the header so that it becomes more descriptive:

YourHeader
(in $.00)

(Use alt-enter to force a new line within the cell)