format number

hello , i have some numbers in my table that i want to show them in millions, but also i have numbers that below the million like thousand, i want the thousand one show with two decimal like 0.25 for 252.300 and for the millions without decimal like 20 for 20.555.0000 Thanks

I've got two columns, department and position. I want to smush them together into one in order to use vlookup from another sheet. The position number needs to be 3 digits long in the final product. I have 1,2, and 3 digit position numbers. I can of course make it show the leading zeros...

I have a column of cells that contain a single text character (A-Z). Some of these entries have a special significance and I want to identify them with an asterisk (eg: A*). However formulas in many other cells reference cells in this column and just typing in an asterisk causes these formulas...

Hi, I'm using Excel 2013. I have added a currency column ($1.00, $1.05, $1.10, etc.) to the slicer - which represents the exchange rates that the users are allowed to choose from. The problem is that the items in the slicer revert back to general format (1, 1.05, 1.1, etc.). I would like the...

Does anyone know how to use vba to format a phone number to the correct format? For some reason when a user enters a phone number with this format: (###)###-#### my script will not change the value to the correct format of: (###) ###-####. The only format difference is the space between the...

In the old versons of excell I was able to format a number such as a cell number to start with 0 and then break the number down to have a space after the third and sixth digit via the custom text field in format number using 0## ### ####. Simelarly I could achieve the same effect with...