formatting a cell

Hi, I'd like to know if it's possible, I'm sure it is, to format a column so that when I enter time in to one of the cells I can just enter 0805 and it is then automatically formatted to 08:05. I just want to do it to save a little time. I've looked at formatting the cells as hh:mm, but upon...

Hey all, We are currently using an excel spreadsheet to upload data to a database. We formatted our cells to "text" so that the 0's in front of our numbers don't disappear. However, when you copy and paste something into that cell it changes the formating and the zeros disappear. Is there any...

Hello, I have problems when these example amounts/figures (in A) are shown using a 3rd party application. Instead of showing the up to two decimal places and with comma (,) if necessary, it only show the following (in B) How can I adjust in the excel in a way that i will get the correct format...

Hi, i'm new to this so ill try to cover as much detail as i can to avoid confusion. For my final year project i have decided to make a hardvard referencing tool using VBA. The Form has a set of radio buttons at the top with the different media options to choose from such as a book, website...

I am trying to develop a x-y scatter plot for a set of data. I have created the chart. In column S beginning in cell 2, I have the values I want on my x-axis. These values are in the following form: Date_time frame. For instance, S2 contains 6/13/2011 8AM-10AM, S3 contains 6/13/2011...

I am creating an excel template that users will mostly populate by pasting columns of information into the template from various other spreadsheets. I need to retain the formatting in the template, however when pasting from another spreadsheet, the format that was copied from other spreadsheets...

I am trying to have cell values of 1-1, 1-2, 1-3, 1-.... My guess is this would be most easily achieved through editing the format. I would like it so when I drag the cell containing 1-1 the next cell will have the value 1-2, and the following 1-3 and so on. Secondly, I would like a cell to be...

Hi there, Anyone know why you can't centre accross selection going from right to left? i.e. info is in the right hand cell... blank space to the left?? :confused: Very annoying! I have a column of figures feeding into a graph, one fig needs to a different colour everyweek, so I have...

I'm looking for the syntax that will allow me to format the totals for the pivot table. for example if I'm summarizing sales by each state with the State being the Row Field how can I bold the totals and shade the cells light grey?

Hi, I have a worksheet where one of the columns uses a drop down box with 5 values. I would like that when I choose a certain value in the box, the next cell to the right is formatted in a predefined way. I tried to use Conditional Formatting, but apparently my wish is to complex. I guess I...

Hello All, I am not getting the desired result from formatting, and I was hoping someone could help, or point me in the right direction. I have created a spreadsheet full of formula's, using mainly two trypes of formula "VLOOKUP" and "IF" formulas. I have created several spreadheets that...

What i want to here is if A1 value is more then B1 value I want C1 value (=B1-A1) to be coloured with blue. Is this possible, thanks alot!

I know there is probably a simple explanation, but I'm missing it somewhere along the way - I am trying to format some cells that contain percentages to show in a parenthesis instead of with the negative symbol: (9.99%) instead of -9.99%. I've even tried custom formatting, but haven't been able...

As far as I know, it's possible to format the text within a cell to the user's liking. For example, if in cell A1 there is the following text: 'My name is Sam' Then the user is free to set My to red, name to blue and bold, and Sam to underlined, etc. I have a workbook. On the same sheet...

I have a huge dataset in columns b of mulitple worksheets that are six digit values. When I try to manipulate them (add together, multiply etc) I get "#VALUE" or "#N/A". If I retype a value over a cell, the manipulations work so it leads me to believe they aren't formatted as values. I have...

I have a list of account numbers that need to be listed as 000-0000-0000. I can format them using a custom format and have the dashes appear in the cell of the work sheet, but in the fx part, the account number is listed as 00000000000. In order for my macro to run correctly in our data base, we...