adding zero th alpha numeric value

M

marziano

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
 
B

Bernie Deitrick

Select column F, and then use Edit / Replace. Replace dash/space with dash space zero.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert numeric values in words. 6
Copying formula results into cells with numerical formats 1
alpha character not populating in DBA table 2
Adding leading zeros 3
Alpha and Numeric in one field 2
How to Convert Numeric Values into Text Values with a Formula 3
Leading zeroes get dropped when converted to text 8
Converting numeric values in words 2

Top