text format

Hi All, I am a newcomer here. I found an old question which I am interested to. https://www.mrexcel.com/board/threads/text-format-for-numbers-to-preserve-trailing-zeros.811427/ I ask anybody to write a Sub file to apply this Function published there...

Hello, I am trying to add custom text formatting that displays in thousands and millions with the conditions below: red text, with an up arrow for positive numbers green text, with a down arrow for negative numbers Here are a couple of examples, hoping for a single text format that...

I have a userform that has various codes that are beingmistaken by excel as date format or something and it keeps changing my formatautomatically. The few of the code types are below. 1 2 3-5 3-17 3-23 3-61 7-81 7-86 How can I get these to stop changing when the userform macroexecutes and...

With the following code... the Search and Replace works find except that all of the numbers are dropping the initial zero. I think I need to add some code to keep the format as text possibly, but I can't find what that code would be. Here is the code: the replacements are returning values of...

Hi all - first post here! (i.e. first time I can't find a solution by searching - this forum has saved my life more times than I can count...) I'm making a dashboard intended to track a bunch of metrics at once. For one of the charts, I'm using the below formula to create the series labels...

I need help scheduling my tweets in bulk. I think there's a way to use Excel to automatically create a 5-day calendar. Maybe a macro? The date format must be dd/mm/yyyy hh:mm and it must be in text format. If its June 9, 2012 at 6pm - the correct format is: 12/06/2012 18:00 I want to post 5...

I'd like to concatenate two text strings but format each part differently, like this: cell A1: Title cell B1: Subtitle Concatenate in cell C1 as: Title Subtitle The source cells (A1 & B1) are unformatted. Easy to figure out the concatenation itself, but I don't know how to do the formatting...

Hello! I'm beginning to lose my mind on this problem. :mad: I made a reasonably complex form, where user (me) must insert a lot of data in (mainly) TextBoxes and ComboBoxes: I wont' bother with translation, but some of you will maybe recognize that I'm trying to calculate heat loses of a...

I have an application on a midrange server that generates a tab delimited file, then invokes a macro-enabled Excel file that I store on that server's integrated file system. That macro-enabled file then saves the generated tab delimited file as a formatted report to the user's client PC. This...

Problem MID(CELL("filename",C2),(FIND("]",CELL("filename",C2))+1),50) returns name of Sheet 1 = 'P&L Sep-10' Then use right() to retrieve 'Sep-10' from this name. This is in a text format, and as far as I know cannot be changed to a date format. My problem lies in using this 'Sep-10' cell...

Hi all, I have two columns. Column A contains years, '2010' for example. Column B contains months, 'Jan' or 'Mar' for example. Neither column is in date format. I want to merge them to 'Jan 2010'. Now that's easy enough, but I also want to make the cell a date and i find that much more tricky...

Having now worked, unsuccessfully, for the last 4 hours on a formula, I am wondering whether anyone can now help. In cell A1 we need to check for the word "DECK" as the 1st four characters, if this is TRUE then we MAY need to amend it in cell A4. If it says DECK 1, DECK 2, DECK 3 and so on to...

I have a over 150 reports that I create weekly and would like the year to change automatically in the cell where I have my copyright info. Don't want to chenge them all by hand each year. :) Should read: Copyright © 2009 TMOReport.com Thanks!

Hey guys!! Ok, I think I have a complicated problem. Hopefully you guys can have a bright idea cuz I'm kind of burn out on this. Every day we receive a text report via email (only way it can be received), so we take this text report print it out and manually type it into an excell sheet. I...

i have a excel file which I want in .txt output. In EXCEL sheet1 A1 contains number, B1 contains name, C1 contains Amount, D1 contains particulars. When I run Macro in text file to be created. In text out put I want spacing for A1 data is 14 {the account number varies from 5 digit to 14...