How to Divide a Number With “Less Than” Sign?
Sponsor
Excel Tips Question:
Please help me to do a calculation from number of conversions from ug –> mg in a column. Many of the numbers that I need to convert have a “less than” sign… ie <1 should convert to <0.001
Excel Tips Answer:
Well, a number with a < sign is not a valid number in Excel, it is a character. and if you are trying to convert it as in your title the result will not be a number either. To do what you subject line asks probably would require a VBA macro.
Here is a excel vba macro you could run against a select range of cell to convert them (only if the leading character is < )
Sub ConvertIt()
Dim cell As Range
Dim x As Integer
Dim First As Double
Dim Second As Double
For Each cell In Selection
If Left(cell, 1) = “<” Then
x = InStr(1, cell, “/”)
First = Mid(cell, 2, 1)
Second = Mid(cell, x + 1, 10)
cell = “<” & First / Second
End If
Next cell
End Sub
Rate This Tips:
(1 votes, average: 2.00 out of 5)
Loading ...Incoming excel search terms
how to divide a number,how to divide in excel,how to divide in vba,how to divide numbers,excel divide by limit,excel divide two cells,how to divede a number in a number,how to divide by numbers less than one,how to put divide in excel,visual basic divide two cells,,a number equals two divided by one less than the same number,add cells then divide by the number of cells,code for divide in excel,devide a number in excel,devide less than data in excel,devide number in excel,divede in excel,divide a number equal in vba,divide by numbers sign,divide formulas in excel,divide in excel formula,divide in excel visual basic integer,divide less than data in excel,divide number in macro,divide numbers macro,divide range vba,divide sign in excel macro,divide with excel date,divide xcel,dividing a number into ranges excel,dividing less than sign,exce lvba code divide number,excel add less than numbers,excel devide,excel devide a number in two cells,excel divide,excel vba divide a range by a number,excel vba divide numbers,excel vba divide numbers in cells,excel vba formula number divide,excel vba how to divide numbers,how to divide by numbers less than 1,how to divide in excel formula,how to divide numbers in excel,how to divide numbers in excel macro,how to divide the number equal excel,how to divide when a number is less,how to divide with excel,how to put less than sign on excel
Related Excel Tips
Comments
One Comment on How to Divide a Number With “Less Than” Sign?
-
Maxx32 on
Thu, 22nd Oct 2009 10:23 am
Besides the paper though, nothing of use can be bought
Have another excel answer or questions for this problem ?
Feel free to post it here..
Best Excel Tips
- Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
- Copy from Worksheet (5.00 out of 5)
- Change Worksheet Tab Colors (5.00 out of 5)
- Delete Worksheet (5.00 out of 5)
- Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
- How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
- Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)
- Calling Macro Visual Basic Procedures of a Different Project
