cell formatting

I receive a document from a customer, for whatever reason they enter the dates as a number. i.e. 20130604 for June 4th 2013. I need excel to recognize this number as a date. Formatting the cell as a date does nothing, I tried playing around with the custom format but I couldn't get it to work...

I need help with a data validation issue. I am trying to use data validation in some cells to restrict what people can enter into cells. In my spreadsheet, there are cells where times are entered and other cells very near this where number values are entered. I was trying to use data...

So lets say that the cell A1 has the number 900 in it. What I want to do is put a formula in B1 that checks to see if A1's character count is odd and if it is odd, then add a 0 in front of the original number from A1. Here's an example. COLUMN A COLUMN B ROW 1 900...

Hi, All, My question appears to be simple, but I cannot find out how to do this: I want to conditionally format some cells, using 2 alternate colours - but I want the user to be able to choose the 2 colours to use. i.e. I want: "if the row no. is odd, then make the cell colour the same as $D$10...

Hello I am trying to format a cell so that it accepts UK Bank Sort Code data. I want the cell to be formatted 00-00-00, however, I used cell format but some combinations of numbers entered, convert it to date format. Can anyone please suggest, how I can format the cell, so that if either a 6...

Hello Guys, I got these problem with validation: 1. I have a DATE in A1 and I want to enter another DATE in B2 using validation (or formula??) such that (a.) If A1 is empty, prompt the message "Enter Planting Date first", and (b) if the date entered is less than (or before) the date in A1...

Hi There, I'm trying to copy formatting from a range of cells to a range of cells on another work sheet that will automatically update when the first one is changed. I found the below thread and tried to use the VBA scripts in it but to no avail...

How can I copy over cell formatting within excel from one worksheet to another ...i can undertsand it not copying to word but excel to excel ....???? please help! I have tried more than 1 way of skinning this cat but it is getting the better of me! :confused::confused::(

I have a spreadsheet where most all the cells are data validated with a drop down list. I only want users to be able to enter name, select drop down variable and finally be able to cut & paste data to other cells. My problem arises when the users cut & paste, the cell borders don't stay...

I have a shift schedule setup. Each half hour is marked by a single character, either an l or t. I am trying to use VBA to change the cell pattern/colors. If a user inputs more than one character the code will change the cell formatting. I would also like for it to prompt the user that they...

I need to use a custom number format (Excel 2003) that adds the "+" sign (w/o the double-quotes) on positive numbers the same way Excel adds "-" sign to negative numbers. I've tried fiddling with it without luck. Any idea? Thanks,

Hi, I need to make a table for every hour for 1 day. I need to a "treatment" cell and 24 "hours" cells in one row. Can someone, please help me make the cells smaller just in these rows without decreasing the cells above them. Thanks in advance. Mark