Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / April 2007

Tip: Looking for answers? Try searching our database.

auto format on number entry

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bbxrider - 10 Apr 2007 00:05 GMT
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.
Gord Dibben - 11 Apr 2007 00:37 GMT
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

>is there some macro/etc that will auto convert entered numbers into 2
>decimal places
[quoted text clipped - 4 lines]
>arrow key that moves
>out of the cell where the number has just been entered.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.