| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding zero th alpha numeric value
hello
i have an mp3 catalogue.column F indicates the location of every piece and the velues in it are in the alpha numeric form of mp3 - xxx. i now need to switch to thousands instead of hundreds. is there a formula that can do this (convert mp3 - 234 to mp3 - 0234)? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding zero th alpha numeric value
Select column F, and then use Edit / Replace. Replace dash/space with dash space zero.
HTH, Bernie MS Excel MVP "marziano" wrote in message oups.com... hello i have an mp3 catalogue.column F indicates the location of every piece and the velues in it are in the alpha numeric form of mp3 - xxx. i now need to switch to thousands instead of hundreds. is there a formula that can do this (convert mp3 - 234 to mp3 - 0234)? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| Alpha-Numeric Sorting | Excel Discussion (Misc queries) | |||
| +1, Alpha *and* Numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
