View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Banker Banker is offline
external usenet poster
 
Posts: 21
Default Excel 2000 - Format Cell - Custom

Using Excel 2000 SP3. I would appreciate help to format columns of cells with
wholes numbers entered as 987654321 and display them as $9,876,543.21. In
other words adding the $ sign, thousands seperator and most importantly
moving the decimal point 2 places to the LEFT. Can anyone show me the correct
customisation format please?