decimal places

I am wanting to have a userform which brings in my information from the user and then outputs it to a spread sheet but I can't figure out how to get it to output in 2 decimal places if the user does not put in the value with any decimal places. I want it to always output to 2 decimals regardless...

Dear community, I need your expert advice! I am working on a sheet to calculate fees. For the amount field, I have used the following formula in "Data Validation": =MOD(E23*100;2)=0 -> The rule should avoid users to enter more than two decimal places. Now I have noticed that odd decimal...

Hi All I cannot reduce the decimal places in the below formula Can anyone help? <colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col...

Greetings. I'm developing a spreadsheet to an accounting firm with tight deadlines and I'm facing a really frustrating issue. I'm doing calculations with currency on a vba sub. The values (in currency) are stored in multidimensional array as single. As I have to perform some divisions, the...

Hello, First time poster so bare with me. I have written a VBA code and am having some issues with a decimal place. Unfortunately i cannot post the code as it is work related. Essentially I have a value assigned to a Variable A using A=Application.Worksheetfunction.round(B,2). when i hover...

Here is my workbook On the Calibration sheet I have a Data Validation drop down menu which allows me to select from Description on the List sheet Table. Each entry has a DP value that they report to.Users can select a balance and start entering weights in the Weight 1 - 10 Rows, but I need the...

I have created a userform and it has several textboxes where the user inputs numbers (these will be financial data prices). In one text box the user enters the Price of the asset. This price can vary in format: it may be £2.27, $123.56 or £64.5902. I want the userform to work out how many...

I am currently working on a spread sheet for my work place where I need to check whether the database's information is accurate compared to the hard copies. I wanted to make it easy to check through the 700 rows of information. I have managed to get an excel document of the database...

Hi All, I've got a problem that I think may be solvable with an array function, however I'm struggling to think of how to put it together and thought y'all would be able to help. My general task is that I'm trying to determine the data type (string, integer, double, etc..) of certain fields in...

Hello! I currently have an Excel file (using Excel 2007 and sharing turned on) with track changes enabled. All of the numeric values in the worksheet are set to 4 decimal places. However, when we make a change to one of the values, the track change "hover-over" note, as well as the change...

Good morning everyone, I have been trying to figure out a formula to convert the amount of months in a certain cell to years. I have come up with: =INT(E29/12)&" years "&MOD(E29,12) & " months" The problem is it comes up with 2 years 3.37063951499227 months Does anyone know how I...

hi I am looking for a way to have Excel check the number of decimal places for a formula. I currently have the following formula =IF(F10 > F8, (F8-F14)*10000, (F14-F8)*10000) which calculates pips for me based on whether the trade is a buy or a sell, but just realised that not all currency...

Hi all, First post here! I have a minor issue which causes major headaches... Excel 2010.... Excel looses decimal places when I copy information from cells. Cell B1: 0.00 Cell B2 2.00 Cell C1: " =B1 &"(" &B2&")" Cell C1 now reads 0(2) - I want it to give the full decimal places -...