? How to input dollars without decimals

I have a lot a numbers to enter and I find it rather tedius to enter
decimals each time.  Adding machines have the "decimal" feature where
you enter the value and it inserts the decimal automatically eg: 10000
is $100.00 and 23578 is $235.78.

Is there a way to add a custom format or a rule to do the above
automatically?

Thanks

A custom numeric formula could be used:
IF This Cell <> -999999999999
Format $99.00

The 99 and 00 are added from the drop down list, not typed.

So, 2001 will be shown as $20.01 but the actual value is 2001.  You will 
need to divide by 100 if you want to use it in some other formula.

It would be easy to fake it with an extra column. Put your entry column 
somehwere out of the way and just enter the digits including the cents, 
no decimal. Then use a formula in the column you want to show = entry 
column divided by 100, formatted as currency

Don

Dawn wrote:
> I have a lot a numbers to enter and I find it rather tedius to enter
> decimals each time.  Adding machines have the "decimal" feature
where
> you enter the value and it inserts the decimal automatically eg: 10000
> is $100.00 and 23578 is $235.78.
>
> Is there a way to add a custom format or a rule to do the above
> automatically?
>
> Thanks
>
>
>
>
>