Hey all, I'm a web developer who's exporting grids of data from webpages into Excel and I'm trying to look under the hood to get some answers. My question: sometimes when I export a grid some of the cells in a numeric column will be "Number" and some will be "General." All the cells seemingly contain nothing but numeric data. By what rationale does Excel decide what cells should be General and which should be Number?
On a related note, I experimented with exporting a currency field. While ALL of the cells had a dollar sign in front of their amounts, only half were "Currency" and the rest were "General" format. Those that were Currency did not display a dollar sign in the formula bar (though they DID display it in the cell itself). Those that were General displayed a dollar sign in the formula bar and in the cell itself. I'm just looking for some detailed info as to how Excel makes these decisions. If it matters, I'm using Office 2003. Thanks! --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
