Abstract: A worldwide number format for use with a spreadsheet program module is disclosed. The worldwide number format includes a locale specifier comprising a number shape, a calendar type and a locale identification (LCID). The worldwide number format also includes a base number format and a value. The LCID is used to categorize different parts of the world. Primarily, the LCID categorizes different parts of the world by language such as English, German, French, Thai, Arabic, etc. The LCID is used to determine what language to display month names, month abbreviations, weekday names, weekday abbreviations, time designations such as AM/PM, etc. The calendar type supports both Gregorian and non-Gregorian calendars. Calendar type is a value to indicate which calendar should be used to calculate the date from the value. The number shape is a value that indicates what shape in which to represent the number.

Abstract: A system and method are provided for delivering broadcast-quality video with targeted advertising to viewers over the switched communication network, thereby providing a viable alternative to traditional cable, over-the-air, and direct broadcast satellite delivery systems. According to one embodiment, program streams with appropriately inserted splice points are transmitted from a network head end node to one or more egress nodes via a switched network. Demographically-targeted advertising is then inserted into the program streams at the egress nodes for subsequent delivery to individual subscribers. More specifically, targeted advertising is inserted in a program stream using a splicing method that employs adaptive synchronization to align splice points in the program and advertising streams that are being spliced together. By appropriately aligning splice points, broadcast-quality video transmission via switched networks is achieved.