Excel and Windows Regional Settings

If you use this formula

=TEXT( 5 ; "dddd")

...and do NOT happen to have English/US settings on your machine (in Windows, not in MS Office), you run into problems:


Important section pasted here to be on the safe side:

Date formatting code problem

The first one is TEXT function where the second parameter is format_text. In Italy it looks like this:
= TESTO (A1;"gggg")   -->   “Mercoledi”

In A1 you have a date. “gggg” stands for the date format long day name (because in italian day = giorno), so the result is for example “Mercoledi” (“Wednesday”).
Unfortunately, if the file is opened by a colleague in his let’s say English computer the result of the formula will be “gggg” - because in English the symbol of day is “d”, and the formula takes the “g”-s literally!
= TEXT (A1, "gggg")   -->   “gggg”

In English only this formula will work correctly:
= TEXT (A1, "dddd")   -->  “Wednesday”

But in this case on an Italian computer you will see “dddd”...

Why it is not possible to use the English “dddd” similarly as in CELL and INFO? Because this day format code comes from the computer’s regional settings, not from Excel’s language setting! (Under Windows 7 you find it: Control Panel / Region and language)

PowerPoint 2007

Turn on the snap-to options

1 On the Home tab, in the Drawing group, click Arrange, point to Align, and then click Grid Settings.

Tip: You can also right-click on an empty area of the slide (not a placeholder) or the margin around the slide, and then click Grid and Guides.

2 Do one or both of the following:
- To position shapes or objects to the closest intersection of the grid, under Snap to, select the Snap objects to grid check box.
- To position shapes or objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, under Snap to, select the Snap objects to other objects check box.

There are no comments on this page.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki