Hi guys I need your help once again. I can update a record from excel through datagrid but I've encounter a problem where instead updating in number/percentage format(I have columns in number format and in percentage format) it updates in General Format. Example:

col1  col2    col3
abc   123.00  100% -------> Both 0 at first before updating
def   456     1 ----------> col2 and col3 doesn't have value. supposed to be 456.00 & 100%

It usually happens if the record I'm updating has no value on col2 and col3 even though cells in col2 and col3 is in number and percentage format respectively. I use the OLE DB Update Method in updating my records in Excel.

3 Years
Discussion Span
Last Post by jared.geli

Yes it is an Excel sheet. In the datagrid it shows my desired format but in Excel it doesn't, I even format a whole column to be in numbers and the other in percentage but it changes it back to General while the other cells doesn't. I'd like to do it programmatically as much as possible instead of doing it manually

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.