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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to program data entry to avoid zeros or last 5 digit. (https://www.excelbanter.com/excel-discussion-misc-queries/65678-how-program-data-entry-avoid-zeros-last-5-digit.html)

sevek

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

Dave Peterson

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

Format|cells|number tab|custom category:
$#.00,,

sevek wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 04:41 AM.