1
  • UK date formatting in MS Excel 2007

    As I enter a date in UK format in Excel 2007 it is taken as text. The date I entered is 23/12/2009. How to get it as a date.

    kotayyam5 pointsBadges:
  • Excel Conditional Formatting 2003

    I have 3 columns with specific dates. The first is a start date, the second is set up to be a week later. The third is blank right now. I have a conditional entered so that if the second column is past the date it will change color to alert me. I want to enter a returned date into the third column...

    pbeadling5 pointsBadges:
  • Can I zoom in on a linear graph in Microsoft Excel?

    I'm looking to create a linear graph in Excel to show the difference between three algorithms. However, the differences are smaller compared to their overall values. Because of this, the lines merge and I can't see the small differences. Is there a way in Excel to zoom in on the linear graph so I...

    ITKE828,755 pointsBadges:
  • Multi-line text from Microsoft Excel without quotes

    I'm creating a multi-line string in an Excel cell by using "Alt-Enter". If you copy that cell to an text editor, Excel automatically adds double quotes around the full string. Cell1 | Simple String 1 Cell2 | First line of a | Multiline string | with 3 lines Cell3 | Another simple line 2 However,...

    ITKE828,755 pointsBadges:
  • Microsoft Excel

    How do you stop Excel from highlighting multiple cells at once when you only click on one? It's really frustrating when doing data entry.

    FHAVEN10 pointsBadges:
  • How do I change a single cell size in a spreadsheet

    I have a spreadsheet and I have set column widths. I would like to change one cell in that spreadsheet without changing the width of all of the rest of the sheet. Is this possible? Also, is there a way to set the page sizes separately i.e. page 1 legal, page 2 letter?

    Cat1005 pointsBadges:
  • Conditional formatting

    Hi there. I want to change the cell colour shading of range A10:F10 to one of three colours, depending on the contents of another cell outside this range (J10). Can this be done please?

    Twiggy196510 pointsBadges:
  • Conditional Formatting – Excel 2007

    Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. In...

    SbElectric2,540 pointsBadges:
  • AS/400 to excel

    How to download an AS/400 file in an excel format. I want to create a tool for this in my system. Please give your guidance.

    GanRek5 pointsBadges:
  • How to convert the currency in Indian Value in Excel 2003

    Dear Sir, I am not able to convert the value like this even by using the custom format in Excel 2003 - 100,75,75,750.50 or (100,75,75,750.50) Can you suggest a good way to do this which also takes care of low values like - 75,750.50  

    Ravichan425 pointsBadges:
  • Crystal Reports 11 problem with excel spreadsheet

    I AM USING AN EXCEL SPREADSHEET AS MY DATABASE. ON THE SPREADSHEET I HAVE A COLUMN THAT HAS NUMERIC AND ALPHA VALUES. WHEN A ADD THIS TO THE CRYSTAL REPORT ONLY THE NUMERIC VALUES DISPLAY AND THE FIELD CANOT BE FORMATTED AS ANYTHING OTHER THEN A NUMBER FIELD. ON THE EXCEL SPREADSHEET THE COLUMN IS...

    SATELE015 pointsBadges:
  • Conditional Formatting – Excel 2003

    Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and "eguals the company in...

    Lhunter5 pointsBadges:
  • Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.

    Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.

    Bpbp5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following