How do I convert 300616a to show as a number 303616?

S

SusanK

I am trying to convert a number ending with a letter to just the number. In
there a function in excel that can perform this task?
 
K

K.S.Warrier

Hi,
try :-if A1=300616a,then
B1=left(A1,6)=300616 (6 in the formula shows the first 6 in A1
Thank you,
K.S.warrier
 
K

Ken Wright

The downside to that is that the LEFT function returns a text string, hence
if you look at Frank's response you will see the double unary preceding his
use of the function, as this coerces the data back to numeric.

Regards
Ken...................
 

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

How can the font and size of (all) citation numbers be altered? 1
Word- Find and Replace 1
WORD VBA Search and switch to advanced ... 1
Excel does not accept text format! 0
Line Numbers Will Not Show 0
Paragraph numbering in Word 1
Delete all data after a symbol in a field 0
Disabling auto-numbering in headings when converting PDF to Word 0

Top