| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding periods (full stops) to the middle of numbers
Hi all
Heres my question and i wonder if someone can help I need to change this number for example 52253580000 into this number for example 52.2535.8000.00 The full stops are after 2 digits then 4 digits then 4 digits then 2 digits Is there a way of doinf this as i have 3000 odd lines to convert :) Thanks in advance Derek |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parsing a full name out into Last, First, Middle | Excel Worksheet Functions | |||
| Separating Full Names into First Middle and Last | Excel Discussion (Misc queries) | |||
| formula for adding x periods/mo add 11% to each | Excel Discussion (Misc queries) | |||
| seperate a full name into first, middle, last, & suffix column | Excel Worksheet Functions | |||
| Adding periods to sentences. | Excel Discussion (Misc queries) | |||
![Derek M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
