| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding into cell
i wish to change a cell that contains "27809980" to "27.809.980" it is a text
cell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding into cell
You can use a formula in another cell:
=CONCATENATE(LEFT(A1,2),".",MID(A1,3,3),".",RIGHT( A2,3)) Andrea Jones www.stratatraining.co.uk www.wrekinpublishing.com "fazz" wrote: i wish to change a cell that contains "27809980" to "27.809.980" it is a text cell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding into cell
=LEFT(A1,2)&"."&MID(A1,3,3)&"."&RIGHT(A1,3)
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "fazz" wrote in message ... i wish to change a cell that contains "27809980" to "27.809.980" it is a text cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| adding a formul to the next cell only with the next cell number | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Adding the same cell in different worksheets. Can that cell be variable? | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Linear Mode
