number formats

  1. F

    PIVOT TABLE Values not Matching Worksheet Values

    Work Day values in the Pivot Table do not match the work day values in the worksheet. Some entries in worksheet show less than a full day (e.g: 0.75 of a day vs. 1 day). I tried to use the cell format function the Pivot Table, but that did not work. How do I get Pivot Table to show values < 1...
  2. Mary90

    Listing all Number Formats

    Good day guys. I'm looking for a way to list all used number formats in my workbook, along with a count of how many cells use each number format. I've tried running a loop through each cell in each worksheet, but I can't get it to work. Google has not provided any usable results :eeek: Does...
  3. Mary90

    VBA: List and count number formats

    Good day guys! I'm new to VBA and use Google to find my syntax, so I may be missing something basic here, but as the title suggests, I'm trying to list all the number formats in my workbook as well as count how many cells actually use them. My code gives results, but the results are wrong...
  4. S

    Need Help on Number format on textbox in userform exel

    Hi Everyone, I need your help on number formatting in excel vba userform. I am using a userform to retrieve data from my excel sheet to my userform. My userform consists of multiple textboxes. i want to format these textboxes as number and the appearance of the data in the texbox would be in...
  5. S

    Figures needs to be shown in Lacs

    Hi All, I want to format a cell in such a way that it should shows figures as if particular figure is divided by one hundred thousand. for example ( if I type 120000 it will show 1.20, similarly 546789 = 5.47) I want to format a cell like that and not to put any formula in the cell. The...
  6. J

    Paste from varied source formats XL2010

    Hi, I am working on a data collection tool that will be used by people across various different countries, unlikely to be of a high competence in excel. The macro I require is a glorified paste special function, which will be added both as a button and a keyboard short cut. The issue that I...
  7. G

    Pivot table number format based on title

    Working with this: For Each pvtFld In Pvt.DataFields If pvtFld.Name = "*Rate*" Then pvtFld.NumberFormat = "%0.00" Else: pvtFld.NumberFormat = "#,##0" End If Next pvtFld So that for each field in a pivot table, if the pivot field name contains "Rate" it will format as a...
  8. S

    Custom number formatting doesn't work when pasted in Word

    I've been pasting linked Excel ranges into a Word document for presentation. In Excel, I've created a custom number format so that negative numbers have brackets but remain aligned with positive ones i.e. "#,##0.00_);(#,##0.00)". However, no matter what type of link or styling option I use, this...
  9. P

    how to delete values with no decimal points?

    Hello all, I have a huge excel file with several rows and columns with quantitative values, which looks like follows.. <colgroup><col span="2"><col><col span="2"></colgroup><tbody> <colgroup><col span="2"><col><col span="2"></colgroup><tbody> 0.551124554119557 0.311702687666443...
  10. D

    Number format

    I have a textbox on a form. The value of this textbox gets transfered to a cell on a worksheet, and the value is expressed as a percentage. For example, when I type, '90' in the textbox, the value should be expressed as 90% on the cell. However, it's displaying 9000%. Here's what I tried...
  11. K

    Combining numbers, text , and numbers with leading 0

    I must be missing something, I just can figure out what.:( I'm trying to combine a two digit date, i.e. "dd" followed by / then 4 digit hour (which is a number) =text(today(), "dd") & "/" & CO23 (where my hour number is in cell CO23) except when the value in CO23 is <1000. I'd like a leading...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top