# number format

1. ### Feet Inches Sixteenths Number Format

I have started a new job in the construction industry and want to continue to be able to use excel in my day to day work as its a very powerful tool that I'm already familiar with. However I've run into a problem in that my firm use the FIS dimension formatting for everything. For those not...
2. ### Number Format from text to number with decimals

I have a string of number 172103000. This is a smart Item number form an erp system. The last 5 digits are the length of the item, for this example it is 03000. I first used the RIGHT function and pulled out the 03000. Now this is a text and I used VALUE to convert to a number. Now I need to add...
3. ### excel 365, two cells, same value, different number format.

i have two cells, which should contain same value but one in text format another in fraction format. Only then excel sheet works, otherwise part of the excel sheet doesn't work. I want only one cell to be drop down in among those two. Please help
4. ### Custom number format

Hi everyone, I can't ind anything about this and I'm not even sure if its possible. I have a file with a lot of calculations. In cell H7 I put a number In cell I7 I have data validation, where I can choose between "Ton, M³ and Un". Can I format cell H7 to have a custom number, where it shows...
5. ### Return Number with -

Hello All, I need this formula to return a 5 digit number with a - and 2 digits it is matching column A on sheet 2 =IFERROR(MAX(OrderNumb)+1,1) In Column a It reads 24001-1 24001-2 And continues till the end I would like it to return 24001-3 I have tried...
6. ### Worksheet.change vs. worksheet.calculate event

I want to add code to some columns in a sheet to define the number format or date format using the following codes ThisWorkbook.Sheets("Report").Range("E2:E" & Cells(Rows.Count, 1).End(xlUp).row).NumberFormat = "mm-dd-yyyy" ' date format ThisWorkbook.Sheets("Report").Range("J2:J" &...
7. ### Getting custom number format from user

Hello everyone, Hope you all are well. I am struggling with a task which requires me to get an input from the user which will specify what number format the user want (currency symbol and the separator to be used). And then save this setting in the windows registry and apply this number format...
8. ### Date formatting

Using a share file on Microsoft Teams Problem: I add data every day and my team use the data for reporting within the sharefile. Every day when we enter Teams and update the data, the dates we use revert to English (US) or Armenian. The date columns are formatted to dd/mm/yyyy using custom...
9. ### Hide data labels with zero values WITHOUT changing number format

Hi, How to hide data labels with zero value? I did a bit search but all solutions suggested are by changing number format. As I already have a defined number format in the chart, changing format is not an option. Also, VBA is not an option.
10. ### Custom Number Format

I would like to create a custom number format where millions are displayed as thousands. I know the formula for that is #,##0,;-#,##0, My problem is that I also need to add an accounting offset dollar sign. So I need \$ 1,000,000 displays as \$ 1,000 with the dollar sign in the same position...
11. ### number format with the flexibility to align

Hi there, I have this number format - _-* £#,##0_-;[Red]* £(#,##0)_-;_-* "-"??_-;_-@_- however I cant align left, centre or align right from the buttons on the ribbon. Is there a way that the above format could be altered to allow me to use the alignment buttons Also is there a way...
12. ### TextBox export back to worksheet as number (%)

Hi, I have got very difficult issue for me and cannot handle it myself :-( Hope experts here can help me. First of all I need to say that I am not good in VB, I am doing sth only from time to time only using hints and manuals. Now I did sth which is very helpful for me, a user form which...
13. ### VBA code problem

Hi I have the following VBA program that works but I would like to make two changes and just not having any luck. The first change is to have the existing "1-1" accept any number combination (say 1-99 or 99-1) right now it only accepts 1-1 as a positive result. My second request is to the have...
14. ### Adding unknown text to custom number format

Hopefully this should be an easy question for someone although I've been struggling with it on and off for months! We have various cells in our worksheet that will always have the following format (example) - WC-18-001A, WC-18-001B, etc. I would like for the user to just be able to put in the...
15. ### Problems formating numbers with hyphens and leading zeroes.

Hi, I'm trying to format a list of phone numbers that are using this number format: ###-### ## ## it starts with a zero and it keeps disappearing and when I enter two zeroes to make it appear there is a space that comes out of nowhere making the format look like this: # ##-### ## ## I don't...
16. ### Conditional Formatting: Change Cell Interior Color (Fill) Only

Hi, I'm trying to use alternate cell shading in excel using MOD(ROW(),2)=1 with conditional formatting in a table. (I'm deliberately avoiding using banded rows here.) I'm setting the fill color to 'No Color' and ensuring that the tabs Number, Font and Border within the conditional formatting...
17. ### Maintaining number format with combining of cells

Hello ! I have a excel sheet with 3 column data 1st column = has sr no. 2nd column = has no. of unit 3rd coloum = has individual total amount value Eg:- <tbody> # Unit TOTAL AMT 1 100 100.00 2 200 400.00 3 300 900.00 4 400 1,600.00 5 500 2,500.00 6 600 3,600.00 7 700 4,900.00...
18. ### Created a column for Month (integer) in a named range, trying to display it as a named Month (ex. "March"), excel keeps reading this integer as a day.

Right now I am working with a data table, to which I added a 'Month' column, as an integer (1 for January, 2 for February, etc.). While pulling this data into Pivot Tables using the Month column, I wanted to display the months as actual names Months - 'January, February', etc. When I edit the...
19. ### Simple Pivot Table Years (number format) in Filter shows as Accounting Format

Hello. This is a weird event in my pivot table. I have a raw/flat file that has a column with years in it formatted as a number (2015, 2016, etc). In my pivot table filters and if used as column headers or values they show as accounting formatted (\$2,017). I've done everything from...
20. ### Combining number formats

Hello, Is there a way I can combine the two number formats: 1. #,##0,;[Black](#,##0,) and 2. 0;-0;;@ In order to get a formatting rule that rounds numbers to the nearest thousand, including the separating comma; puts negative numbers in brackets; and hides zero values? Many...

### 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 MrExcel.com.

### Which adblocker are you using?

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

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
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