Thread: Changing format of column from "general" to "currency"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Old Car Old Car is offline
external usenet poster
  
Posts: 9
Default Changing format of column from "general" to "currency"
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.


Reply With QuoteReply With Quote