1. B

    VBA Get Function

    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...
  2. D

    Formatting Truncate

    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?
  3. B

    Parimutuel Odds Calculation

    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...
  4. G

    Truncating instead of rounding

    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...
  5. M

    Format Special Text

    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...
  6. P

    Truncate results of a formula

    =(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...
  7. T

    loop truncating and renaming sheet vba excel

    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...
  8. V

    Custom formatting code - rounding problem

    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...
  9. R

    text math

    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...
  10. A

    TRUNC function Error

    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.
  11. V

    Remove last 19 characters from a field

    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"...
  12. W

    Lookup of rounded number fails for certain numbers

    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...
  13. E

    Truncate vaiable text strings???

    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...
  14. P

    Lost Text When Using Two Instances of Excel

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

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

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