When I change the Format|Cells|Number|Category of a selected column from
general to currency, any existing numeric data does not change to the
currency format ("$#,##0.00"). If I add new values, they take the currency
format. How can I force all of the existing values to take the new format?
Thanks.