Split Symbols Of Tally Numbers

[Nitin Suntwal]

Hi There,

I have exported excel file of stock summary from tally. In thet file i need UOM (Unit Of Messurment) from one of the column. I googled & found a code which is working fine. After lot of R&D I came to know that the code is not working for the quanties which are in units value ex: (0.129 or 1.000 or 9.123) .

Can someone help me to know what is that I am missing.

Attached is my sample file with the codes added in sheet level in VB. Sheet 2 is working fine but sheet 1 is not working.

Thanks In Advance!

Regards,
Nitin Suntwal.

 

[shrivallabha]

Following code works with your sheet 1 data.

Public Sub GetUOMText()
For i = 2 To Range("A" & Rows.Count).End(xlUp).Row
    Range("B" & i).Value = Split(Replace(Range("A" & i).NumberFormat, """", ""), " ")(1)
Next
End Sub

 

[Nitin Suntwal]

This works accurately. Thanks Shri...