rounding

Hello, I need to keep my numbers in thousands (ie. 456,798 as 456.798 or 7,000 as 7). In addition I need to have all cells that equal zero be displayed as dashes "-". How do I format my cells? Thanks!

I have a problem copying data from a range via a query. The source range contains several numerical fields precise to 5 decimals to the right of zero. When the routine pastes values into the new sheet however, the numerals are rounded slightly - example $159.45497 somehow becomes $159.45500...

I'm wondering how this might be possible either via VBA or fancy formula work... Essentially I'd like to get to a specific value when using a percent to total calculation, but because of rounding I'm slightly off...is there any way to make sure we get to the specific value? For Example: I...

Hi Everyone, The following code converts my excel file to a fixed length text file, however I need some of the columns to format to 2 decimal places. Can someone let me know how to change the coding to accomplish this? Thanks! Option Explicit Sub CreateFixedWidthFile(strFile As String, ws...

Hello, I am trying to build a calculation that rounds up customer requests in increments of 12, based off a set percentage threshold to roundup at. Column A would have percentage % to round up to the next 12, example 0.01% would roundup the next 12 at customer requests >= 12.12 Threshold...

Hi everyone, Thanks for taking the time to read my thread! I was hoping that someone can please help me out. I tried to format cells to 2 decimals, but when I generate a tab delimited text file, the real cell values are shown, which have far too many decimals. Would appreciate it if I can get...

Hello Everyone, Hope you are all doing well. Happy Friday! I have a question about values in an IF formula. Im trying to write an IF formula that will recognize a number between 0 and 1. When this number is inputted the formula will be TRUE, otherwise it will be FALSE. Here is my example...

Hello, this is my first post on these forums, so please let me know if there is anyway I can improve my post. So we receive interest rate values in Excel spreadsheets constantly. These interest rates are always (and must be) in multiples of 1/8, so 0, .125, .25, .375, and so on. However...

Hello Guys maybe you can help me out am using Round(....,2) function.... Lets say Tom gets a salary of 1333.33 every 2 weeks, 8% of that needs to be taken out every time he gets paid so thats 106.67 each time.... in one sheet i have 106.67 listed two times and when its added i get 213.34. In a...

I am pulling data via odbc microsoft query. One of my fields has the formula Round(GL01+GL02+GL03, 2). It returns only two decimal places in the query, but creating pivot causes extraneous data after two decimal places. I then proceeded to add a column to results of the query rounding that...

Hello, I'm running into a small problem here that I'm hoping someone can help out with. If I forecast a small number of units for a group of customers, then break it down based on historical customer sales, how do I sort out the rounding so that the break down will equal my group forecast...

Hi all, I'm having a slight issue with rounding on my excel sheet at the moment. I have two cells which contain separate calculations - I11 and C14. I11 is a sum total of 3 other cells - =I8+I9+I10 (872) - while C14 is a simple average - both I11/3 and AVERAGE(I8:I10) have been tested...

Help! I have users input a number into a cell. I want that number to automatically format to have 2 decimal places. Then I am using that number and equation to auto-fill another section that has units also autofill in the cell. See below: Left = Auto-filled from right side entry...

Hi. I'm new here and have been trying to find an answer to this forever... I believe this might be of interest to other users as well. My problem is: after I press F2 + Enter on a calculated cell, excel changes rounding to match the formula's outcome decimal places. Question: How do I prevent...

I am having trouble with my VBA code it appears that I need to run the code twice in order to have the code process all of the data. The code should first refresh all pivot tables then copy and paste the data from pivot table 1 to a worksheet. After pasting the data, all negative values need to...

Hi, I am designing Python code that would dump the excel contents into CSV file on Unix server and have a problem with numbers When the values are dumped into CSV, I want to have the values that appears in the cell to be dumped rather than the real values of double precession's which is...

Hello everyone! I own a bakery and I'm trying to create an ingredient inventory sheet. Each night I have a sheet that updates automatically how many dough batches I should make. The batches must be whole numbers since I can't make a half batch of something with the large mixer that I'm using...

i have some prices that need rounding down to the nearest whole 5 or 9 e.g. 81.75 - 79 126 - 125 33.75 - 29 Any help would be much appreciated!

Hello People of the Internet, I have encountered rather a strange problem in Excel, proven in 2007, 2010 and 2013, on both Windows XP and 7. To reproduce - in Excel: - Enter the precise value: 12586.4767 - Press Enter - Go back to the cell you've just typed into, and look at the value in the...

Hi all, Good afternoon! I have some scores ranging from 10 to 100 with two decimal values. I want to round them as follows (in another column taking these values, not a formatting solution). Scores Rounded <tbody> 15.25 15.00 15.49 15.00 15.50 15.00 15.51 16.00 15.65 16.00 15.99...