truncate

Hi all I have a scenario where I need to truncate a number to 4 decimal places ( no rounding) . I have searched google and this site and found the Get() Function. This function works great IF the decimals to 4 places are greater 0 ( 515.1234678 gives me 515.1234) however if the number is to...

I have a cell with 5581004490451CS: 200. I don't want the whole text displayed (it was imported from a database). I would rather it display only "0451CS: 200" Any easy ideas?

I have a program for a charitable gaming calculator but don't understand exactly what the formulas do. There are six entries per 'race'. The formula is: IF(TRUNC((total bets all 6 entries/2)/bets on this one entry)=1,2,TRUNC((total bets all six entries/2)/bets on this one entry)) I...

I've inherited an Access database. It pulls the amount of pounds sold of our products from our sql server and converts to tons by pounds/2000. However, it truncates after 2 decimals which leads to a huge amount of error. I tried changing the format to 4 decimals but it just takes the existing 2...

I'm running XL version 2010. I have a question about formatting for a special text character. If I have values such as 3.6.9 and 3.6.10 that correspond to product versions, is there a way to format the special text editor to have the numbers after the second decimal treat them as 9<10, while...

=(F16+I16)/4 The formula above is a calculation that gives me the number of months to use in an additional calculation after adding to cells at contain a number representing "weeks." In this case: F16 =34 I16 = 4 38/4 = 9.5 In the result cell, I have elected to show 0 decimals, therefore...

Hi, i wrote this code to truncate a cell in a sheet, then rename it with the new value of this cell and delete the whole row afterwards. I need this to loop through all the sheets with the value of B1. here is what i have so fare but it doesn't seem to work. Dim workS As Worksheet For...

Here the problem raises with rounding the two decimal values. But i need like using trunc in custom formatting. I need the values not to get rounded with decimal but display as it was. Problem 1 [>=1000000]$#0.00,, "M";[>=100000]$#0.00, "K";$#.00 this code converts millions and K with 2...

Hello everyone, my laziness is catching up with me and I'm wondering if anyone has ever faced the following issue - I'd like to "subtract" text from a cell and keep the remainder (using a formula), though that might be too good to be true? Given the following original...

He're's my data: 98.9000000000 (location Register!N1006) I'm using this formula: =TRUNC(Register!N1006, 2) This should truncate the number to 98.90, but I get 98.89. What gives? Screen grab - if this works I'm using Excel 2010 on Windows XP.

Hey Everyone, I am a total excel noob how can i remove the last 19 characters from a field for example: <table width="652" border="0" cellpadding="0" cellspacing="0"><col width="652"><tr height="20"> <td style="height:15.0pt;width:489pt" width="652"...

In this sample, test values that round to -0.102 or -0.104 lookup incorrectly, returning the next higher result in the table. Test values that round to the the other values in the lookup range return correct results (e.g. -0.100999, -0.105000). Truncating the rounded value causes all lookups to...

Is there a formula to remove everything after a certain character for variable text strings? for example: Turnthis... Single basin|,Double basin|,Triple basin| Double handle|,Single handle|,Touchless| Single hole|,Two holes|,Three holes|,Four holes|,Single hole with deck plate| into this...

Hi. Copying and pasting cells from a worksheet in one instance of Excel to a worksheet in another instance of Excel results in the text being truncated. I have a laptop display extended to a VDU so I have two instances of Excel open so that I can view two Excel files at the same time...