text formatting

Currently I am trying to have variable decimal formats displayed across a range of cells. The amount of decimals will depend on how large the numbers are. The numbers range from 100,000.00 to .000000001. I can get this formula to work properly and it displays the decimals as I have...

I'm not even sure Excel has this capability. I have 2010 and 2016 versions so an answer that works for either is fine. Basically, I have a column that's pure text / general and I want to Bold certain parts of the text based on their contents. Because all the cells are quite similar with only...

Hi, Just out of curiosity I was wondering if and how to do this efficiently. This is the case. One of the users here has produced a long list of data. The data is always build up in equal format. AAAA123456 The 123456 is changing for every line, while the AAAA is changing only a few times over...

I have a pivot which uses another external spreadsheet , connected via "use an external data source" The data source has two columns , one for "Actual Spend" , one for "Budgeted Spend" . Both columns in the source file are formatted as Currency format and display as currency with no problems...

Greetings I have a report that contains a batch number which is formatted YYMXXX where the month is represented by a single letter. These letters are sequential from A=Jan, B=Feb etc. I don't have a problem manipulating my data until that fateful month of May when my 13E123 suddenly becomes...