| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add decimal point from last 2 digit
Does anybody has a macro which would add a decimal point from last 2
digit of a selection of numbers eg 12345 would change to 123.45 34567 to 345.67 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add decimal point from last 2 digit
x = 12345 / 100
seems too obvious ! Regards, Peter T wrote in message ups.com... Does anybody has a macro which would add a decimal point from last 2 digit of a selection of numbers eg 12345 would change to 123.45 34567 to 345.67 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| In excel, how can i delete 1 digit and the decimal point? | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| round a 15 digit decimal down from .05 | Excel Programming | |||
Linear Mode
