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

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