View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default Same column Percent and Currency

Hello I have a column that contains numbers thatr represent both
percent and currency. Presently I formatted the column as number - general
Example 0.15 and 68 - 0.15 should read 15.00% and 68 should read
$68.00. Is there a formula so that I can format the number as percent or as
currency in the same column thanks