# Calculating a decimal into a round number

#### brooksc29

##### Active Member
I have a data set with decimals out to the 1000th. Each 1000th represents 1 day. For this exercise, there are 172 days in a year. Is there a formula that will calculate the following decimal into a total number (total days)?

Example is 5.137.

where .172 = 1. (every time the counting number reaches .172 it goes to 1.000 and starts counting again to .172).

The result I need to get is 997.

I'm not sure how to write the formula to convert any text with three decimals to a round number counting the decimals points as singular days.

Any ideas?

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### shg

##### MrExcel MVP
 a​ b​ c​ 1​ 5.137​ 997​ b1: =172*dollarde(a1, 172)

#### brooksc29

##### Active Member
awesome! so if I have the round number (997) how would I convert it back into the decimal?

#### shg

##### MrExcel MVP
Ici:
 A​ B​ C​ 1​ 5.137​ 997​ B1: =172*DOLLARDE(A1, 172) 2​ 5.137​ B2: =DOLLARFR(B1/172, 172)

perfect!

thanks!

Yer welcome.

Replies
9
Views
998
Replies
3
Views
5K
Replies
0
Views
614
Replies
6
Views
454
Replies
4
Views
542

1,191,633
Messages
5,987,787
Members
440,110
Latest member
albertod8

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

### Which adblocker are you using?

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