variety

Good Evening.... I have a column with dollar amounts, as such, for example " $21.85. Any amount with a zero at the end will not show when I do a drop down list at data validation. For example...$18.50, will show as "18.5". I do not care about the $ sign, but I need that zero at the end. I have...

morning all, fairly new to excel and trying to stream line a way we do stocktake we currently have a variety of silo sizes with a variety of powers from 70 tonnes to 105 tonnes is there a way i can create a formula to automatically calculate the tonnage once we dip the silo and measure...

morning all, fairly new to excel and trying to stream line a way we do stocktake we currently have a variety of silo sizes with a variety of powers from 70 tonnes to 105 tonnes is there a way i can create a formula to automatically calculate the tonnage once we dip the silo and measure...

Good morning, when I run the code listed below it works perfect until I get to an empty cell then the Set Fnd area highlights yellow and I have to Debug. I've tried the If Fnd is Nothing then Exit sub (actually tried a variety of that) it just ignores it. I've also tried to use a message box...

In a1 i have a variety of single variable equation such as : -3 -6x = -15 .... I need a way to separate the three parts in the next three columns showing the following: b1 "-3" , c1 "-6x" and d1 "-15" the other type of equation is where the <tbody> x variable is at the front such as 3x +4...

Can someone please tell me the correct syntax when using the "If Isdate" command when referencing a range in another worksheet that is not active? I've tried a variety of guesses and none work, such as "If Worksheets("Inactivesheetname").Cells(3,1). isdate then". Yes, it makes no sense, but...