Two parts: I want to be able to type "234." and have it read 234.00. If I
do it now I get "2.34"

Part two: On one form I have a colum of sold item, so I need only whole
numbers. In order to get say "2" I have to type "2.0". How do I format to
just get thewhole number? Thanks

Hi

Format CellsNumberNumber set to 2 decimal places for first request,
and set to 0 decimal places for your second request.

Regards

Roger Govier



CKB007 wrote:

Two parts: I want to be able to type "234." and have it read 234.00. If I
do it now I get "2.34"

Part two: On one form I have a colum of sold item, so I need only whole
numbers. In order to get say "2" I have to type "2.0". How do I format to
just get thewhole number? Thanks

Pull-down:

Tools Options Edit and clear the Fixed Decimal checkbox
--
Gary''s Student


"CKB007" wrote:

Two parts: I want to be able to type "234." and have it read 234.00. If I
do it now I get "2.34"

Part two: On one form I have a colum of sold item, so I need only whole
numbers. In order to get say "2" I have to type "2.0". How do I format to
just get thewhole number? Thanks