View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sevek
 
Posts: n/a
Default How to program data entry to avoid zeros or last 5 digit.

How to set Cell format so enterd numbered shows figers in millions with two
decimals.

Example: Like to enter $3,234,856

Excel should show $3.23

I can title excel "all numbers are in 10,000