LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 29th 20, 06:44 PM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: May 2020
Posts: 1
Default MS Excel 2010 uses Russian for "Sheet" in new workbook


I use Excel 2010 on a Windows 7 Home 64-bit system with the Russian language pack installed (my wife is Russian and also uses this computer).

When I create a new spreadsheet from Windows Explorer using File New Excel spreadsheet (or from the context menu), the spreadsheet has the tabs named in Russia, so instead of "Sheet", it uses "List".

I have UK English, US English and Russian installed according to the File Options Languages settings, with UK English set as the default language and keyboard (the US English and Russian keyboards aren't enabled, just the spelling and grammar rules for these).

Windows is set to use United Kingdom as its location in the Region and Language applet in the Control Panel.

Does anyone know how I can correct this behaviour please?

Best regards,
Richard Watt

  #2   Report Post  
Old December 24th 20, 11:00 AM
Junior Member
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
Default Here's a VBA workaround

Sub SetLanguageFormat()

Dim cell As Range
Dim f As String
Const LCID As String = "[$-0409]"
Dim reg 'As RegExp 'Removed for late binding

'Setup regular expression
Set reg = CreateObject("vbscript.regexp")
reg.Global = True
reg.IgnoreCase = True
reg.Pattern = "\[\$\-+[\w]*[\w]\]"

'Loop through all cells and change the date formate
For Each cell In ActiveSheet.UsedRange.Cells
If IsDate(cell.Value) Then
f = cell.NumberFormat
If reg.Execute(f).Count 0 Then
'Language is set so replace it
f = reg.Replace(f, LCID)
'Langauge is not set so add it
f = LCID & f
End If
cell.NumberFormat = f
End If

End Sub

Let me know if this was useful.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add "paste values" to right-click shortcut menu-how do? Excel 2010 Chet Excel Programming 1 June 27th 10 11:23 PM
Visual Studio 2010 (Creating Excel DLL) "warning" no build [email protected] Excel Programming 4 May 30th 09 03:40 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Excel "Move or Copy" and "Delete" sheet functions dsiama Excel Worksheet Functions 1 December 28th 07 01:57 PM
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook JingleRock Excel Programming 0 April 25th 06 05:04 AM

All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017