| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert 300616a to show as a number 303616?
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? |
|
#2
|
|||
|
|||
|
Hi
try =--LEFT(A1,LEN(A1)-1) -- Regards Frank Kabel Frankfurt, Germany "SusanK" schrieb im Newsbeitrag ... 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? |
|
#3
|
|||
|
|||
|
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 "Frank Kabel" wrote: Hi try =--LEFT(A1,LEN(A1)-1) -- Regards Frank Kabel Frankfurt, Germany "SusanK" schrieb im Newsbeitrag ... 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? |
|
#4
|
|||
|
|||
|
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................... "K.S.Warrier" wrote: 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 "Frank Kabel" wrote: Hi try =--LEFT(A1,LEN(A1)-1) -- Regards Frank Kabel Frankfurt, Germany "SusanK" schrieb im Newsbeitrag ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How I convert number to word | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
| how can i convert a number in words? | Excel Discussion (Misc queries) | |||
Linear Mode
