| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a period into exsisting cells?
Ok!
Peo Sjoblom wrote: Oops Forgot the formula =SUBSTITUTE(A3,LEFT(A3,2),LEFT(A3,2)&".",1) -- Regards, Peo Sjoblom (No private emails please) "Dave Peterson" wrote in message ... But watch out for things like: 26260G Peo Sjoblom wrote: Another way =SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".") -- Regards, Peo Sjoblom (No private emails please) "Dave Peterson" wrote in message ... =left(a1,2)&"."&mid(a1,3,255) JM wrote: Sorry I should have made it clear. Yes the it will be always be inserted after the first 2 digits. I need to insert the period after the first 2 digtis. 26150G to 26.150G 33207G to 33.207G 03273G to 03.273G 05069G to 05.069G and so on. Thanks JM "Peo Sjoblom" wrote: What's the rule where to insert it, will it always be inserted after the 2 character like in 23.150G or what would the rule be? -- Regards, Peo Sjoblom (No private emails please) "JM" wrote in message ... Hello, Is it possible to insert a period into the middle of a string of numbers? I have 800 numbers I need to change in A1 to A801. Can I do this without having to retype the entire column? Here's an example: I need to change 26150G to 26.150G Any help will be greatly appreciated. Thank You JM -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert a drop down date picker to worksheet cells? | Excel Worksheet Functions | |||
| insert copied cells | Excel Discussion (Misc queries) | |||
| insert rows and update linked cells | Excel Discussion (Misc queries) | |||
| Insert Formula and Copy to other cells | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
