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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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