DwZone Forum Welcome to the DwZone-it Forum     FAQ   Search   Memberlist   Usergroups       Register -->   Login   Import/Export Tools   DwZone Forum Index -> Import/Export Tools Moderators: Administrators, Moderators  Mark all topics read Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes. Search for  View  Normal Expanded Dynamic Dynamic Memory Threaded Threaded Expanded Threaded Dynamic    Per page  102550    Messages Since  Last Visit Last Day Last Week Last Month Last 6 Months Last Year All Messages 131 to 140 of 382 (Total: 233) First |  Prev |  Next |  Last    Subject Author Date      Re: Export Access to XLS (XLS Write)    Gianluigi   10:45 10 Mar 2011      Re: Export Access to XLS (XLS Write)    Laurent   10:49 10 Mar 2011      Re: Export Access to XLS (XLS Write)    Gianluigi   11:14 10 Mar 2011      Exporting Zip Codes to Excel File    ALJ   9:08 1 Mar 2011      Re: Exporting Zip Codes to Excel File    Gianluigi   9:11 1 Mar 2011      Re: Exporting Zip Codes to Excel File    ALJ   9:35 1 Mar 2011      new to the extension    Jos�AntonioViadas   20:24 29 Jan 2011      Re: new to the extension    Gianluigi   22:57 29 Jan 2011      Re: new to the extension    Jos�AntonioViadas   23:05 29 Jan 2011       Formatting Numbers    AnthonyMalloy   19:26 29 Jan 2011     Hi, I am generate an Excel spreadsheet from a MSSQL Recordset. I have values stored as decimals (8,2). Is there anyway to format these as numbers when exported instead of string? If I set the export type to Number it seems to multiply by 100 to remove the decimals so 105.00 beomes 10500. I'd like my client to be able to sum columns without having to format the columns.       Last Visit: Tuesday 10 Jun, 2025 6:26 am First |  Prev |  Next |  Last    Login Username:  Password:   Log me on automatically each visit:   Read Message   Unread message Read message [popular]   Unread message [popular] Read message [locked]   Unread message [locked] All times are GMT-2 Jump to:  Select a forum    Php Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Mail  » Advanced Search  » Ajax DataGrid  » Ajax loader  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Server Side Validation  » Shopping Cart  » Site Search Engine  » TreeView  » Two tables manager  » Upload and resize  » WYSIWYG Html Editor  Asp Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Search  » Advanced Mail  » Ajax DataGrid  » Ajax loader  » Asp TreeView  » Asp Upload and Resize  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Routing Map24  » Server Side Validation  » Shopping Cart  » Site Search Engine  » Two tables manager  » WYSIWYG Html Editor