How to program data entry to avoid zeros or last 5 digit.

S

sevek

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
 
Top