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...

    ITKE351,965 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,...

    ITKE351,965 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following