Support for the new Turkish lira in Microsoft Office

Applies to
2003 version of the following Microsoft Office 2003 programs: Access 2003, Excel 2003, FrontPage® 2003, InfoPath® 2003, and Visio 2003

2002 version of the following Microsoft Office XP programs: Access 2002, Excel 2002, and FrontPage® 2002

2000 version of the following Microsoft Office 2000 programs: Access 2000 and Excel 2000

By Tania Ward

Contributors: Sharon Zhou, Sirirat Manorodpradit, Paul Anderson, Aileen O'Connor, Gil Sta. Maria, Darren Miller, Levent Acar, Robert Chen, Rajesh Kamath, Josh Berts, and David Moran.

Summary    This article describes the level of support that is offered in Microsoft Office to support the new Turkish lira. Topics covered include an overview of the level of support for the new Turkish lira in Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000, FrontPage, and Visio.

Contents

Introduction

Microsoft Office has taken several steps to ensure that our customers in the Turkish market are able to continue business as usual and that the changeover to the new currency, the new Turkish lira, is transparent.

Office programs that require a Windows update

The following Microsoft Office programs require the New Turkish Lira Currency Symbol Converter Tool in order to be able to support both the old currency, TL, and the new currency, YTL. These programs are Access 2003, Excel 2003, and Visio 2003.

  • The New Turkish Lira Currency Symbol Converter Tool, which is a Microsoft Windows update, is applied only if your user locale is set to Turkish (in Windows Control Panel, click Regional and Language Options).
  • If you install the tool and then change your user locale to a different locale other than Turkish, you will need to reinstall the tool.
  • In installing the tool where the user locale is Turkish, the default currency setting will become YTL. If you change the default currency to be TL, you will need to reinstall the tool again.

Microsoft Office programs that require a code fix

The following Microsoft Office programs require Office-specific updates to be applied to support the old currency, TL, and to display the new currency, YTL. These products are InfoPath 2003, FrontPage 2003, and FrontPage 2002.

Microsoft Office 2003

Among the programs that ship with Microsoft Office 2003, three programs contain some currency references. These programs are Access, Excel, and InfoPath. More information on how each program is able to use both the old and new currencies is discussed later in this article.

Access 2003

Access as a database allows users to create a variation of different data types. One of the data types that a user can create is a currency data type. It is possible to select the currency format associated with this data type, because a number of different formats presented to the user are based on the default currency associated with the user locale, which is defined in Control Panel in Regional and Language Options. The formats listed are based on the default currency for that locale, as shown in the following illustration.

General tab

Installing the New Turkish Lira Currency Symbol Converter Tool will provide you only the choice of YTL or TL format. To get around this restriction, users can customize their own format by entering #,00"YTL"; -#,00"YTL" in currency data type.

When you enter data, it will be formatted as the custom format — when you click the value in the column, you will see the TL but it will revert back to YTL.

Currency Symbol Converter Tool

 Notes 

  • If an Access database contains a currency column formatted as TL, and the New Turkish Lira Currency Symbol Converter Tool is applied to the computer, the format on the existing Access database will be preserved, hence TL will be preserved.
  • If the user creates another currency column of type YTL on an existing database and the New Turkish Lira Currency Symbol Converter Tool is removed, the YTL format will still be preserved.

Exporting and importing between Windows SharePoint Services and Access

In exporting an Access database table that contains a column of type currency and formatted as YTL to a Microsoft Windows SharePoint Services list, the YTL will be converted to a TL. In importing a Windows SharePoint Services list that contains a column of currency type TL to an Access database, it will be formatted as YTL; that is, if the New Turkish Lira Currency Symbol Converter Tool has been applied to the computer; otherwise, it will be formatted as TL. In the case where Windows SharePoint Services has a currency column formatted as YTL, when this list is imported into Access, these characters will become corrupted.

Importing between Excel and Access

In importing Excel 2003 content into Access 2003, the following needs to be considered:

  • Scenario 1     The New Turkish Lira Currency Symbol Converter Tool has been applied to the same computer that hosts Access 2003, and the computer's user locale is set to Turkish:
    • An Excel 2003 worksheet that contains both a YTL and a TL currency column will be mapped as follows:
      • A TL currency column in Excel will be mapped to a currency type formatted as YTL in Access.
      • A YTL currency column in Excel will be mapped to a currency type formatted as YTL in Access.
  • Scenario 2     The New Turkish Lira Currency Symbol Converter Tool has not been applied to the same computer that hosts Access 2003, and the computer's user locale is set to Turkish:
    • An Excel 2003 worksheet that contains both a YTL and a TL currency column will be mapped as follows:
      • A TL currency column in Excel will be mapped to a currency type formatted as TL in Access.
      • A YTL currency column in Excel will be mapped to a number type. The workaround to this problem is to open the worksheet in Design view, change the type to currency, and enter the customized format.

In importing Access 2003 content into Excel 2003, the user will lose the currency information. The workaround to this problem is to select the cell or cells and change the currency to YTL by using the YTL Currency Macro Add-in, or alternatively, by following the instructions at Currency or Accounting format.

Excel 2003

The level of support offered by Excel 2003 for the new Turkish lira will be restricted to the New Turkish Lira Currency Symbol Converter Tool and the YTL Currency Macro Add-in for Excel. In Excel 2003, there are two formats that can be applied to a cell that will format the cell based on a currency format. These formats are the Accounting and Currency categories. In addition to the cell formatting, Excel integrates with Windows SharePoint Services where SharePoint Services can export its content to an Excel worksheet.

Currency or Accounting format

It is possible to format a cell as a currency or accounting cell by selecting a cell or cells and on the Format menu, clicking Cells and, under Category, selecting Currency or Accounting.

Format Cells dialog box

Only the old currency, TL, will appear. In order to have access to the new currency, YTL, you need to install the New Turkish Lira Currency Symbol Converter Tool. Once this tool is installed, YTL appears as the default, and the option of selecting the old currency, TL, will be available.

Number tab

Supported scenarios:

  • You will only get the new currency after the New Turkish Lira Currency Symbol Converter Tool has been applied.
  • Worksheets that contain Currency or Accounting cells created with the old currency, TL, will be preserved once the tool has been applied.
  • Worksheets that contain Currency or Accounting cells that contain both YTL and TL will be preserved if the tool is removed or overridden.

Export to worksheet

This is specific only to a currency data type. There are a number of different applications that have the ability to export content to an Excel worksheet. A good example of one of these applications is Windows SharePoint Services, where it is possible to have a column of type currency that can be either TL or YTL (once the Windows SharePoint Services Update has been applied and the workaround followed). In either case, both will default to TL on exporting to Excel. The user can easily fix this issue by selecting the cell or cells and changing the currency to YTL by using the YTL Currency Macro Add-in or, alternatively, by following the instructions at Currency or Accounting format.

Importing Access data into Excel

See Importing between Excel and Access.

The YTL Currency Macro Add-in

Click YTL Currency Macro Add-in to download the add-in. This tool is only in Turkish, and after it is installed, you can add or remove it from the toolbar by pointing to Toolbars on the View menu.

View menu, Toolbars command

Once the YTL Currency Macro Add-in is enabled, the user can at any time select a cell and:

  1. Format it as an Accounting or Currency cell.
  2. Choose either TL or YTL.
  3. Add the YTL ISO format.

Turkish Currency Tools

InfoPath

InfoPath 2003 supports the new Turkish lira through this InfoPath 2003 Update (KB887982). This update is only supported on versions that are running Service Pack 1. The level of support is restricted to only English and Turkish releases of InfoPath. This update will add the new Turkish lira (YTL) to the following sample forms, which include a currency drop-down list:

  • Absence Request
  • Asset Tracking
  • Change Order
  • Expense Report (Domestic)
  • Expense Report (International)
  • Invoice (Single Tax Rate)
  • Invoice (Multiple Tax Rate)
  • Invoice Request
  • Project Plan
  • Purchase Order
  • Purchase Request
  • Sales Report
  • Status Report
  • Time Card (Detailed)
  • Time Card (Simple)

Microsoft Office XP

Among the different products that ship with Microsoft Office XP, two products contain some currency references. These products are Access 2002 and Excel 2002. Below we discuss in greater detail how each application is able to use both the old and new currencies.

Access 2002

The workaround will be the same as for Microsoft Office Access 2003.

Excel 2002

The workaround will be the same as for Microsoft Office Excel 2003. There are some issues around displaying the new YTL currency in both PivotTable items and PivotChart items. The user can still work around this issue by formatting the actual currency to be YTL.

Microsoft Office 2000

Among the different products that ship with Microsoft Office 2000, two products contain some currency references. These products are Access and Excel. Below we discuss in greater detail how each application is able to use both the old and new currencies.

Access 2000

The workaround will be the same as for Microsoft Office Access 2003.

Excel 2000

The workaround will be the same as for Microsoft Office Excel 2003.

Back to Top

Visio 2003

The level of support offered by Visio for the new Turkish lira will be restricted to the New Turkish Lira Currency Symbol Converter Tool. In Visio, it is possible to create a custom property of type currency. Once a template is selected, you can navigate to Shape and click Custom Properties. Click Yes to define a new custom property and select Currency from the Type list.

Define Custom Properties dialog box

There are five formats available for currency custom properties. The first three presented to the user are based on the user locale, which is accessible in Windows Control Panel by clicking Regional and Language Options and setting the user locale on the drop-down menu. These three formats will change based on whether the New Turkish Lira Currency Symbol Converter Tool has been applied, and, if so, they will be changed to YTL. The last two formats are hard-coded and will not be affected.

Define Custom Properties

This means that if you have a text field based on a custom property, after the New Turkish Lira Currency Symbol Converter Tool is applied, text fields based on currency custom properties always display the new currency if a text field with units is used.

It is further possible to insert a text field in a Visio object that displays the contents of a custom property. If a Turkish currency custom property is displayed through a text field, and a field format that includes units is selected, the text field will always display the new currency after the New Turkish Lira Currency Symbol Converter Tool is installed, regardless of the format chosen for the underlying custom property.

In this case, the only way to ensure currency custom properties for both the Turkish lira and the new Turkish lira is to create currency custom properties as follows:

  1. Turkish lira: Use 2,75 Turkish lira or 2,75 TRL.
  2. New Turkish lira: Use any of the top three formats and ensure that the New Turkish Lira Currency Symbol Converter Tool is installed.

FrontPage

FrontPage 2003 and FrontPage 2002 provide features and functionality that help customize and build Web sites. One of these features is integration with Windows SharePoint Services. In opening a SharePoint Services site through FrontPage, it is possible to:

  • Add a column to a SharePoint Services list in which the column can be of type currency.
  • Create a Data view of a SharePoint list that contains a currency column.

In the first case, FrontPage has had to provide a code fix to support the new Turkish lira. This will be described under both the Microsoft Office FrontPage 2003 and Microsoft FrontPage 2002 sections.

In the second case, where you want to import a SharePoint Services list that contains a currency column as a Data view, you can overwrite the existing currency symbol. This can be done by going to Format Item as, clicking Currency and then entering TL or YTL in the Symbol box.

Format Number dialog box

FrontPage 2003

FrontPage 2003 supports creating a new currency column of type New Turkish Lira through Microsoft Knowledge Base article 890337. This KB article will only be supported in conjunction with applying the Windows SharePoint Services version 2.0 update, which is accessed through KB article 888505. In applying both updates, you will be able to create and edit currency columns of type New Turkish Lira in FrontPage for Windows SharePoint Services lists. The level of support is restricted to only English and Turkish releases of FrontPage 2003.

Once the updates are applied to both FrontPage and Windows SharePoint Services version 2.0, you will be able to do the following:

  1. Add a column of type currency = New Turkish Lira to a list:
    1. Open a Windows SharePoint Services site in FrontPage.
    2. Expand the Lists folder.
    3. Right-click the list.
    4. Click Properties.
    5. Click the Fields tab.
    6. Click Add button.
    7. Enter a field name in the Field Name box and a description in the Description box (optional). Select Currency under Information Type. Click Next.
    8. Under Display Format, select New Turkish Lira.
    9. Click Finish.
  2. Edit a column of type currency = New Turkish Lira:
    1. Open a Windows SharePoint Services site in FrontPage.
    2. Expand the Lists folder.
    3. Right-click the list.
    4. Click Properties.
    5. Click the Fields tab.
    6. Select the Currency column and click the Edit button.

 Note   After a New Turkish Lira currency column has been added to a Windows SharePoint Services version 2.0 list, you can edit it only by going through FrontPage. In the case where you edit the field by using Modify Columns and Settings, you will not find the New Turkish Lira string, and an existing column that was tagged as New Turkish Lira will revert to Algerian. The following will not be supported with the fix:

  • Formatting the currency through the Data Grid.
  • Using smigrate.exe from a Windows SharePoint Services version 2.0 Service Pack 1 site containing the KB article fix to a Windows SharePoint Services version 2.0 SP1 site without the Turkish fix. The fix needs to be applied to both computers.

FrontPage 2002

FrontPage 2002 supports creating a new currency column of New Turkish Lira through Microsoft Knowledge Base article 890849. This KB article will only be supported in conjunction with applying the SharePoint Team Services version 1.0 update, which is accessed through KB article 890850. In applying both updates, you will be able to create and edit currency columns of type New Turkish Lira in FrontPage for Windows SharePoint Services lists. The level of support is restricted to only English and Turkish releases of FrontPage 2002. The level of support offered is the same as what is offered in Microsoft Office FrontPage 2003.

Back to Top

 
 
Applies to:
Access 2003, Excel 2003, FrontPage 2003