auto format on number entry

B

bbxrider

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.
 
G

Gord Dibben

Tools>Options>Edit.

Check "fixed decimal places" and set to 2 places.

Note: this is global setting so all workbooks/worksheets will be affected.

Otherwise, event code can do the job for a specific range or worksheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top