Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transform calendarized data | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Number Transform to Date | Excel Worksheet Functions | |||
how do I transform data from excel to spss? | Excel Programming | |||
Transform a Cell from Formula to Number | Excel Discussion (Misc queries) |