| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a decimal from the right of a string
How can I insert a decimal into a number? I need to insert this before the
fourth character in the string from the right? I cannot insert this from the left of the string because the number of characters in the sting to the left can vary. For example: I need to change 4577600 to 457.7600 Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| How do I enter a decimal in a string of numbers in Excel? Example. | Excel Discussion (Misc queries) | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
