or
<div> <telerik:RadGrid runat="server" ID="RadGrid1" AutoGenerateColumns="false" AllowPaging="true" AutoGenerateEditColumn="true" > <MasterTableView EditMode="InPlace"> <Columns> <telerik:GridBoundColumn DataField="Col1"> </telerik:GridBoundColumn> <telerik:GridDropDownColumn DataField="Col2" ListTextField="value" ListValueField="index" UniqueName="DropDownColumn"> </telerik:GridDropDownColumn> </Columns> </MasterTableView> </telerik:RadGrid> </div>Imports Telerik.Web.UIPublic Class WebForm6 Inherits System.Web.UI.Page Private _isBound As Boolean = False Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Private Sub RadGrid1_ItemCreated(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemCreated If TypeOf e.Item Is GridDataItem Then If Not _isBound Then DirectCast(DirectCast(RadGrid1.MasterTableView.GetColumnSafe("DropDownColumn"), GridDropDownColumn).ColumnEditor, GridDropDownColumnEditor).DataSource = GetDropDownData() _isBound = True End If End If End Sub Private Sub RadGrid1_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource RadGrid1.DataSource = GetGridData() End Sub Private Function GetDropDownData() As DataTable Dim dataTable As New DataTable() dataTable.Columns.Add("index") dataTable.Columns.Add("value") For i As Integer = 0 To 19 dataTable.Rows.Add(New Object() {i, i}) Next Return dataTable End Function Private Function GetGridData() As DataTable Dim dataTable As New DataTable() dataTable.Columns.Add("Col1") dataTable.Columns.Add("Col2") For i As Integer = 0 To 19 dataTable.Rows.Add(New Object() {i, i}) Next Return dataTable End FunctionEnd Class<telerik:RadNumericTextBox ID="rntNumber" ShowSpinButtons="true" Width="50px" MaxLength="3" runat="server" Value="50" MinValue="10" MaxValue="200" NumberFormat-DecimalDigits="0"> </telerik:RadNumericTextBox><asp:ImageButton ID="infoBtn" runat="server" width="20px" height="20px" BorderWidth="0px" ImageUrl="../Images/Info.gif" />

I'm currently exporting to Excel a RadGrid and I have some cells that have the text "1 / 10" meaning that they had 1 hour used for 10 units. When this gets to Excel, it thinks the cell is a date, so it changes the cell to be January-10 which is not what I'm wanting.
I've gone the other direction before (changing a string to a number/date by setting the cell style's mso-number-format property) but I've never had the issue where I needed to make Excel keep the cell as a string and not try to change the format.
How do I do this? I've tried adding a apostrophe to the beginning of the cell text:
e.Cell.Text = String.Format("'{0}", e.Cell.Text);
<telerik:RadGrid Width="95%" ID="pogrid" runat="server" AutoGenerateColumns="true" OnColumnCreated="Grid_ColumnCreated" CellSpacing="0" > </telerik:RadGrid></div>protected void Grid_ColumnCreated(object sender, Telerik.Web.UI.GridColumnCreatedEventArgs e) { if (e.Column is GridBoundColumn) { GridBoundColumn col = (GridBoundColumn)e.Column; if (col.DataTypeName != "System.DateTime") { col.AllowFiltering = true; ...<telerik:RadAjaxPanel runat="server" ID="pnlSchedule" EnableAJAX="true"> <telerik:RadScheduler runat="server" id="radSch">
<AppointmentContextMenuSettings EnableDefault="True" />
<TimeSlotContextMenuSettings EnableDefault="True" />
</telerik:RadScheduler></telerik:RadAjaxPanel>