View Single Post
  #1   Report Post  
CMD@WTMA
 
Posts: n/a
Default currency with auto decimal and comma separator in a table

How do I get a cell to automatically convert a number to currency with a
decimal point and comma separators? I do not need a formula in the cell I
would just like to type a number, say 5000, and have it automatically convert
to 5,000.00.