# decimal

1. ### Number Format from text to number with decimals

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...
2. ### Type Hindi numbers and show decimal numbers when necessary

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...
3. ### Conditional formatting the number format of a chart

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...
4. ### RANDBETWEEN Two decimal numbers to produced a decimal number

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...
5. ### Rand with decimals (positive value + negative value)

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.
6. ### VBA - decimal separator issue

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...
7. ### Rounding only if the 3rd decimal place is greater than 5

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...
8. ### Timesheet Calculation

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)...
9. ### Formula if(cell-cell<>0;"ERROR";"OK") just works with some numbers

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...
10. ### Error on number formatting on VBA - Very Strange...

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...
11. ### Excel formula to get the result by few rules in 1 cell.

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...
12. ### Hours.Minutes to Hours.Tenths

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.
13. ### Converting number to fixed length field

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...
14. ### VBA List Separator

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!
15. ### Format Cells

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
16. ### vba form

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?
17. ### Decimal signs "," & "." - causing issues

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...
18. ### How can I generate a number patterns from a source value

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
19. ### convert decimal input to real time vba code

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 . . .
20. ### Increase OR Decrease the complete value

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back