View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amkake amkake is offline
external usenet poster
 
Posts: 1
Default Formatting Cells

I enter 5562815 in a cell, then try to format it to currency. I've tried all
the choices and it changes to $5,562,815.00 instead of $55,628.15 like I want
it to.
Help!