number formatting

Hi all, Im having an issue formatting telephones basically I've a large list of mobile and landline numbers in different formatted e.g some are 0741 1088291 others are 07 411 088 291 and more I need them to be 07411 088291 and the same with land lines. I have used different variations of...

I want to format a list on US telephone numbers so that a character string of 80055555552265 Would display as +1.800.555.5555 Ext 2265 This works as long as the Ext is 4 characters long +1"."###"."###"."####" ""Ext"" "#### But it does not work for an Ext number of less than (or maybe even...

I apologize if this has been covered. I did quite a bit of research, but wasn't able to find anything that helped me (maybe I was using the wrong terminology). I have a very large spreadsheet with a list of clients with several sub categories for each client. I need 2 formulas (preferably, no...

I need to take the number below and divide it by several numbers, (a different number to divide by each row). 2891966705430700585 I want to know whether there is any sort of add-in for excel that will let me do math with numbers larger than 15 digits.

Pretty much I just need to be able to have zeroes in front of numbers without converting the number to text. And also note that the numbers that I am going to be pasting in that cell need to be able to be any size and still be able to keep the zeroes in front of them. popcornrulez

Is there a formula for taking two cells and merging the data. Here's and example of what I want to do: A1="00000080" without quotes and B1="7652" without quotes. I want a formula that when I put the formula in C1 I want C1 to equal "000000807652" without quotes. Any help with this would be...

Hello. Thank you in advance for any help/guidance you all can provide. My issue is as follows: I have standardized report I use on a daily basis, this report contains social security numbers(SSN) without the leading zeros. I need to add the leading zeros to be able to use the correct SSN for...

I am currently using formatting for certain cells with Number and 3 place decimal. (Example 37.250 and 125.125 ) What I would like to do is have the 0 not show up if it is on the end of the number. I would like for it to look like this 37.25 instead of this 37.250 Thanks as always....

Please help! I am working with two worksheets. In sheet 1, I have two columns: Column A: Account Number Column B: Property Address In sheet 2, I also have two columns: Column A: Account Number Column B: Property Number What I want to do is add a Column C to sheet 1, and include the...

Hello everyone, I would like help with displaying a number as dollars and cents in a concatenation formula. My current formula is ="Location 1 "&Sum(G5:G13). This prints the location and the sum of the those cells, but the number looks like 32437.31 instead of $32,437.31. Can...

When I create reports at work, I seem to be constantly adjusting the number of digits after the decimal point. What I really want is, say, three significant figures, whether they be 0.123, 1.23, 1230, or whatever. Is there a way I can tell Excel to give me as many decimal places as it takes to...

This seems to be the oldest Excel question in history. And yet, having read various pages around the web about how to solve it, I still haven't found a solution that I've been able to implement successfully. My data sheet has a Month column, and those months are simply numbers one to twelve...