The Format property affects how values are formatted for display, not the values stored internally. To retrieve the formatted value of a cell, use the GetDataDisplay(Int32,Int32) property.
The Format string has the same semantics as the format argument in the .NET System.String.Format(System.IFormatProvider,System.String,System.Object) method. For details and a complete set of examples, see the .NET documentation.