Thread: formatting cells
View Single Post
  #1  
Old March 16th, 2010, 08:14 PM posted to microsoft.public.excel.worksheet.functions
pat67
external usenet poster
  
Posts: 137
Default formatting cells
Hi, I am trying to format cells that contain dollars in millions and
make it decimal. i.e $1,500,000 would show $1.5 and the head of the
table would say "Dollar Value in Millions" any ideas? Thanks