format cells

I have the following text in Excel 17661TJBA020Y1 and would like to use a custom cell format to show this way: 17666-TJB-A020-Y1 I do not want to use a formula, just the custom format in place in advance, thanks.

Hello; I want to format [452365214] as [452, 365, 214]. Separating by comma and space.

Hi I'm struggling to change the format of my information to show reading ages in the YY/MM range. I already have info and when I custon and change to YY/MM it changes all the years to 19 from any year age ie 10/11 = 10yrs 11 monthes. but when I custom format the cell it changes to 19/11 -...

Hi All I am working on some vba and i haven't got to the point where i will need this yet but i know it will be useful. I am looking to compare 2 columns lets say A and B where they contain values (Not empty) and the length of the columns are always different. (A and B will be the same length...

I'm working on a Template that will be Themed buy a few members on a monthly basis. All the Sheets are protected and the user is to basically just Background Fill the Cells, etc. All Sheets are to be Themed Identically. But to avoid doing the same thing on each Sheet, they group the sheets...

I need to create a custom prefix that will work with cells that contain both number only and number and text data. I've used "000-0"#### but that only works with number only cells. I've also tried "000-0"@ but it only displays the text. There must be a simple solution I can't think of! Many thanks

I'd like to find a way to automatically be able to format dates as yyyy-mm-dd hh:mm:ss without having to keep retyping that in the Format Cells -> Number -> Custom section. Is there a) any way to automatically be able to add this as one of the options so I can simply select it or b) is there...

I have a workbook which is linked to a master workbook and contains formatting within cells such as bold,italic etc but only parts of the cell are formatted. I've been trying to find out how to retain this formatting when using the paste link function but so far without any joy. I've tried...

Hi, I would like to format a excel file to "General", but it's not working for all cells (some are custom, pourcentage...). here is my code : With ActiveSheet.Range("A1").Resize(LineIndex, 1) .Value = WorksheetFunction.Transpose(strLine) .NumberFormat = "General"...

Hi all, I am looking to move data from this format: <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</style><![endif]--> <tbody> Trading Name: BRAD GARLICK FORD Division: [...

Hi Experts, I am facing a problem. Whenever i put a phone number into cells it converts to formulas and i tried finding the solutions on google and found some solution format cells etc but nothing is helped me. I have shared a pic sample below. Please help if someone knows a solution it. Also I...

Hi everyone, I am a newbie in VBA and I need some help to format my sheet. I am trying to color the values in my pivot table, and I have some troubles to find a dynamic way to extend the new format when new lines are added to my file. What I want the macro to do is basically to color each cell...

Hi Everyone, I am calculating a date time timestamp but come up with an answer of ######### due to it being a negative d:h:m example: 7/1/2015 1:30 PM - 7/1/2015 1:27 PM = ######## What I would like to see for an answer is the actual negative number in the d:h:m format (i.e. - 0:0:03)...

I have data in column A that I would like align right if =(LEFT($A10,4)=" ") is true. Is there a way with VBA to run through all of the rows in column A and apply the align right to all the cells that are true? Thanks for your help!

User enters text into a cell such as: T2K5G1. I want the custom format to convert that to: T2K 5G1. So it's the same thing with just a space in between. I tried 000 000 in the custom format but that didn't work. Suggestions?

I am working on an excel file to help with our meeting minutes with my job. Currently every time there is a new item or minute the updater has to manually insert and format the cells. I want trying to make a macro that will work by clicking a button towards the bottom that will add 4 new...

Hi guys, I am trying to format a column to display numbers as 16,00 or 1654,00 but i am unable to format the cells appropriately and can only get a result of 16.00 and 1,650.00. I need any future number entered in the column/cell to use this format so using a =TEXT(cell,"0,00") formula or...

I have a schedule in Excel. On Sheet1 I have a legend that dictates cell colors based on value. Examples: cell value = 1, cell is grey and text is bold cell value = 1T, cell is grey cell value = 1F, cell is grey cell value = 2 cell is blue and text is bold cell value = 2T cell is blue...

When I try to change formatting in a spreadsheet A, I get the following message: 'too many cell formats' When I try to copy data from   spreadsheet B to spreadsheet A, I get the following error: ‘Microsoft Excel cannot paste the data’. However, when I copy data from spreadsheet B into a new...

A popular product has an Export to Excel with a single column for Date / Time. The format shown has the date [comma] Time. It won't convert to a Date date type due to the comma. A popular software tool takes this data off of the internet and converts it to this text string. I can manually use...