View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carina Carina is offline
external usenet poster
 
Posts: 2
Default How to customize number to 10 digits including 2 digits after deci

I want to to display numbers into 10 digits including cents but no decimial
point ".". For example: $0.01 display as 0000000001 or $100.00 display as
0000010000. Can some one help?