formating

Hi guys, I'm using a web query to take some information from a file HTML file I have, but I'm having some troubles with formating things. In "P" column I take scientif number and Excel erase the first "00", there are any way to change this? Here is my HTML code...

Good Morning, How can you create conditional formatting with several conditions? For example.. <colgroup><col span="7"></colgroup><tbody> GRADE ON 200 MESH </tbody> 20EXT24 15 20EXT24 32 ULD 14 ULD 24 I am...

I would like to be able to apply conditional formating to my report but am having trouble with the VBA code. What i would like to do is apply a condition to several Text boxes in the details section of my report. I want to be able to highlight in yellow the max value in each text box source...

Hello Everyone, I'm new to vba and need a little help getting certain cells formatted based on their date in number value. I basically have a large calendar displayed in row format as shown below. The numbers displayed are actually number values associated with the date (ie Oct 1 is actually...

I would like to try to use my Function I have been using in Excel in a VBA code to do stacking in EXCEL. I have some data that is coming out of a program in a formate that is not usable and needs to be reformated. The function I use is...

Hi Experts, I need your help. I am actually converting addresses into GPS coordinates "Longtitudes and Lattitudes". I am using a website where input around 200 addresses and they provide output in a csv. You can see the image below. The formating is little bad. All the data is good but they are...

I have a vlookup that I am trying to clean. It evaluate a column that contains things like 100000. Only that 100000 is a text format not a number format. I have to keep it in a text format because that is the way my spreadsheet is pulling data from an ODBC server that has preset queries and...

Hi everyone, I am working on a file that requires constant use of underscores. I would like to hide these underscores. I having been trying to find a way to select all instances of underscores (in unhidden and hidden sheets) and change the font to transparent. The closest I got is the...

Hi I am using a user-form to allow a user to log weights from a set of scales. I have a combo-box which allows them to choose a formula. When they choose an formula I display the :- amount, the batch#,expiry date. on labels on the userform. everything is working apart from formatting the date...

Dear all, The tables that I have created in Microsoft Excel and then pasted as Pasted Link as Microsoft Office Excel Worksheet Object in Powerpoint get automatically resized (width and height increased) as soon as I press Updated Link in Powerpoint. As I am working with a Powerpoint...

Hi there! I'm having some dificuty with my excel skills, in a nutshell I'm creating a inspection log grid an my cells are formated to change colors I.E: 1= green 2= yellow 3= orange 4= red what im trying to do is to create a section at the bottom to count the amount of cells with the same...

Greetings, I need to find the second blank cell after cell 'P14' and format its contents as a percentage. I am presently using this code: Range("P31").NumberFormat = "0%" How can I specify the range so that it finds and formats the second blank row after P14 as a percentage? The problem...

Hi all, I've had a good look and I can't find exactly what I'm looking for which is: I get a spreadsheet with, sometimes, 500 chars in a cell. I want to load this data to an application but I can only load up to 60 characters per column (for reasons I shan't bore you). Therefore I want to...

Hello. I am creating a simple inventory, and for one of the columns I would like to have a range of sorts. In theory it would look like "$30 to $50". I was wondering if there were a way I could just enter "30 50" and it would format it to two separate currency units with a "to" between them...

I am using excel 2007 I need to format a column that calculates the difference in military time. I have the time calc formula, I need to format the entire column to preform the formula. I currently need to stretch the column's cells down the column and this has proven problematic with...

I have 3 pivot tables in my workbook with the same data source. Each pivot table is on a different worksheet. I want all pivot tables to automatically update the filter when one of the pivot table report filters is changed. The macro I am currently using to create the pivot tables from my raw...

I am trying to conditionally format using AND() to reference if there is a value in the top line of a table and the title in the right most column for each cell in the table, the formula I am using works when i paste it into cells (i get the correct TRUE or FALSE for each cell in the sheet) but...

Hello I have a data sheet with hundereds of rows sortes by Column Cat.No. some rows have the same cat.No.(Cat.No. 0566A55 appears in 3 rows for example ) i want to have all rows with the same Cat.No. with same color but when the Cat.No. changes. i want that the color overturned to a...

Hey, I am making a matrix that tracks the the deliverables of a long project. So lets say I have the expected start and end date of all the phases of the project in column A and B respectfully and columns C and D are blank but are to be filled out with the realized dates that phases of the...

I need a Code to put on to my sheet so if a cell contains a line of text such as "france" it will turn blue... also id like to do this for multiple different titles such as italy, wales, england, scotland and ireland... all of these to come up in different colours on entry...