number transform right at data entry
 

is there some macro/etc that will auto convert entered numbers into 2
decimal places
like an adding machine,
i dont mean to convert after the number is entered and then run a macro that
divides by 100
but essentially doing the divide by 100 when either return is hit or an
arrow key that moves
out of the cell where the number has just been entered.

number transform right at data entry
 

--
---
Regards,
Norman
Microsoft Excel MVP



"bbxrider" wrote in message
...
is there some macro/etc that will auto convert entered numbers into 2
decimal places
like an adding machine,
i dont mean to convert after the number is entered and then run a macro
that
divides by 100
but essentially doing the divide by 100 when either return is hit or an
arrow key that moves
out of the cell where the number has just been entered.

number transform right at data entry
 

Hi BBX,

Try:

Tools | Options | Edit | Fixed Decimals


---
Regards,
Norman



"bbxrider" wrote in message
...
is there some macro/etc that will auto convert entered numbers into 2
decimal places
like an adding machine,
i dont mean to convert after the number is entered and then run a macro
that
divides by 100
but essentially doing the divide by 100 when either return is hit or an
arrow key that moves
out of the cell where the number has just been entered.