View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
INEEDHELP
 
Posts: n/a
Default How do I format to currency when number includes cents?

I have a worksheet that I'm working on which contains figures which I need to
convert to currency but the amounts in the columns include the cents (ex.
81223) this number should be $812.23. Is there a way to format this?