#microsoft-excel-2007

Resolved: How can you make Excel 2007 stop formatting large numbers as scientific notation? #solution #it #computers

How can you make Excel 2007 stop formatting large numbers as scientific notation?

Kind of the inverse of this question.

I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let’s face it, Excel is an ideal tool for this sort of thing.

Except for one behavior: Excel attempts to outwit the data in the CSV, and therefore, if…

Fixed: Why does Excel 2007 changes the text "HSA"to "HAS"? #solution #development #computers

Why does Excel 2007 changes the text "HSA"to "HAS"?

Working on Excel 2007 I am trying to populate a cell with the text HSA. However, when pressing enter, the text changes automatically to HAS.

I assume there is a kind of auto spelling correction here, but I can’t find how to disable it (and, preferably, only at this cell).

Answer [by KCotreau]: Why does Excel 2007 changes the text "HSA"to "HAS"?

Fix: How to remove white space from a number #fix #dev #it

How to remove white space from a number

I have a column of number with white spaces in them. Like this: “32 445 423“. How do I get rid of all the white space to get excel to treat it as numbers rather than strings?

EDIT: Let me fill in some additional information that has come to light. My goal is to turn “32 445 423” into a 32445423. If I write in the string “32 445 423” into excel and use =SUB…

Fix: Adding Weeks to Current Date in Excel 2007 #answer #it #computers

Adding Weeks to Current Date in Excel 2007

How can a given number of weeks be added to the current date in Excel 2007? For example, if I need to add 12 weeks to the current date, 12/6/2010, how can that be done?

Answer [by Sathya]: Adding Weeks to Current Date in Excel 2007

=TODAY() + 7*12

or in general,

=TODAY() + 7*(no of weeks)

Original post

How to: Hyperlink font in Excel always changes to the default font face/size #solution #fix #programming

Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).

How can you configure Excel to use the same font face/size as you selected for the entire sheet (or group of cells) and not the default font set in Excel (in Excel 2007 the…

How-to: How to stop Excel from Auto-formatting and making it work like a number crunching program #development #fix #answer

How to stop Excel from Auto-formatting and making it work like a number crunching program

I have a real problem with Excel in csv files where it is formatting numbers in certain ways and I cannot seem to get Excel to display the data right no matter what I do.

Imagine I have a colum called “Product Reference”. Within that column I have many IDs of the type:

001145

55666

02133

Whenever I open the…

Answer: How can I prevent the privacy warning in Excel? #answer #computers #programming

How can I prevent the privacy warning in Excel?

I have Excel 2007. When I want to save a spreadsheet, I often see this message:

I’ve seen this with macro spreadsheets (using the .xlsm extension) and with non-macro sheets (using the .xlsx extension).

How can I prevent this warning every time I save my spreadsheet?

Answer [by thane]: How can I prevent the privacy warning in Excel?

Try this:

Offi…

How-to: Is it possible to paste CSV formatted data into Excel 2007? #development #programming #fix

Is it possible to paste CSV formatted data into Excel 2007?

I want to copy and paste CSV formatted text into Excel 2007.

Is there a way of doing this without saving it to a temporary file first?

I’m sure in previous versions of Excel there was a way to trigger the CSV import wizard by hand in this situation, but I don’t know how do this in Excel 2007.

For reference, in OpenOffice this Just Works…