# Help with interest rates formatting

#### golf4

##### Active Member
Hi everyone -

Just a quick question: I'm continuing to develop an income calculation spreadsheet for a public housing agency. What I'm looking for is help in asset interest rate cell formatting. I've got the cell(s) formatted for "percentage", but in cases where staff wants to enter ".91" for .91%, the cell appears as "9.1" instead. Is there a way to format the cell(s) that would enable us to enter ".91" and have to formula calculate as, for example, "\$5000 x .91%"? THANKS FOR THE HELP (AGAIN)!!!

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Hi
Your staff will need to understand that .91 = 91/100ths or 91%. .091 is what should be entered for 91/1000ths or 9.1%. I understand your problem. Excel has just chosen the mathematically correct way to display the value. Not the plain English way.

Tom

Hey Tom -

Thanks for the help. I really appreciate it.

Could use custom number format 0.00"%" and divide the cell by 100 in calculations.

Yep, you need smarter staff, or a clever programmer

If the Wizards haven't suggested a Validation scheme, perhaps there is need for some code in Worksheet_Change.

If this sounds like the path you want to take, then post further information.

The rough outline:

Worksheet_Change is triggered.

It checks which cell is being modified.

If the cell is your "problem" cell, then the code would need to step in and make judgement on how to modify/validate the entry.

You would need to imagine yourself watching over the user's shoulder. What are you watching for? A range of values? A specific format? Is there a "dead giveaway" when the entry is bad? Is there a "dead giveaway" when the entry is good?

Please get back with us, this sounds like a challenge.

Replies
1
Views
331
Replies
5
Views
2K
Replies
12
Views
685
Replies
0
Views
425
Replies
2
Views
939

1,220,954
Messages
6,157,042
Members
451,394
Latest member
indrajeet_rajput

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

### Which adblocker are you using?

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

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