decimal

I have a string of number 172103000. This is a smart Item number form an erp system. The last 5 digits are the length of the item, for this example it is 03000. I first used the RIGHT function and pulled out the 03000. Now this is a text and I used VALUE to convert to a number. Now I need to add...

Hi, I have a workbook, it has integer and decimal numbers. I want to achieve two things: The numbers must be in Hindi format. The decimal numbers must remain as they are without any rounding, and the integer numbers must remain as they are. I want to achieve those two things with in mind...

Hi all, I'm trying to find a solution for a chart in PowerPoint, but I assume that if there's a way to do it in Excel it would also be applicable to my query. I'm trying to achieve the following. I have a column chart and I want to force it to show only the values <3% with 1 decimal place, and...

Howdy, I am stuck on a formula and am hoping someone here can help me. Essentially, i am doing a tolerance sheet. Showing the design value, the actual value and the difference between the two. There is a tolerance of +0.015 and -0.000. So if the difference falls out of this range i need it to...

Hi guys, I am tryin really hard to find a solution to this but no luck so far. I need two sets of random values. 1. Between 1 & 4. With one decimal 2. Between -17 & -20. With one decimal Can you please help me achieve this? Thank you heaps.

Hi, I have a data set in the html page looking as table containing numbers, dates, times, strings etc. each in separate column. I'm trying to copy this data set to excel and format it as I want with VBA. The only problem I have is that the source data set is using DOT "." as decimal separator...

Hi everyone, I have a task where I need to round a number up to 2 decimals ONLY IF the third decimal place is greater than 5, otherwise it'd stay as it is. For example, if the figure is $26.24701 then round it to $26.25 If it's $26.24301 then keep the 5 decimals. I've been trying to run an...

How can I complete this timesheet? I need Total Time worked (End Time less Start Time less Break) and Total $ Due. I've tried it with the Break as minutes or hours or x24, formatted as h:mm or 0.00. I just can't get there. Can you help? Date Start Time End Time Break (Minutes) Break (Hour)...

Hi all, I am working with a formula that is driving me crazy... it seems to work, but if I change one decimal, then does not work properly. I have prepared two examples to explain better: In Example 1, when I use the formula IF(C5-C7<>0;"ERROR";"OK"), it says "ERROR", which means that...

1) I have an excel sheet with values (Numbers) that represent dollar amounts. 2) I have a Userform that has labels that update the values according to the amounts on the Excel Sheet... Everything was running smoothly until I opened the excel worksheet with a PC (I work on MAC Excel 2011) in...

To seek help on excel formula to auto detect below 3 rules in 1 cell. Please advise. Rules: If decimal in cell more than 0.20 = 0.50; If decimal in cell more than 0.70 = 1; If decimal in cell less than 0.20 = 0. Amount (USD) Wanted Result (USD) 1,074.67 1,074.50 238.84 239.00...

I have a spreadsheet where time is reported in hours.minutes and I need to report in Hour.tenths of an hour to one decimal, rounded up. Not sure what the formula should look like.

Hi all, Not VBA related at this stage but I will be hoping to convert it into VBA in the long run. I need to convert a number, which will be of indeterminate length, into a text string of fixed length. The length is 14 characters long. To fill the length, I need to add leading zeros to the...

Hello Everyone! I have a question about List Separator, so it is possible to change list separator via vba code? I know the decimal can be changed via vba, but I didn't found anything about list separator. Thank you for help!

Hello Friends, I want to format the cell that allows me to enter both positive & negative number with 1 decimal place. Like +1.0 or -1.0 regards, Humayun

Hello I need a vba form with two fields, one of which is a drop down list of names and the other is a decimal value to store names in the cell and a decimal in the comment. Then I want to formulate and calculate on the decimals inside the comments. Can anyone help me?

Hi, I have a template that calculates costs for services per month based on input from managers. I have set dot/"." as default decimal sign whilst everyone else have comma/"," (applies to all excel files you open). Due to this, they can not see the calculated costs for rows that contain cells...

Hello i have a little problem here. , how can i fill colomn B faster. problem - > https://i.imgur.com/X7qf5vs.jpg ERJXGNJ7R8Y - where the R in 7R8Y stands for a decimal = 7.8 ERJXGNJ753Y * where the 3 in 753Y is the decimal place = 75000.0 video here - > https://streamable.com/4ssy1

Hi I need a vba code that converts a decimal input to real time and does nothing if it's time. for example: 2.5 convert to 2:30 3.5 convert to 3:30 and if input is time do notting 2:30 convert to 2:30 3:30 convert to 3:30 . . .

Column B is updated with RTD Output required in Column C as: If 3rd decimal place >=5, then INCREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple ELSE DECREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple Thanx in adv I am using...