Last post Jul 27, 2011 03:04 AM by princeG
Jul 27, 2011 02:47 AM|Feeling|LINK
The excel file column that i want to retrieve data is integer value.I had try retrieve value beside that column but also get integer value, just one of that column get default datetime value.Anyone know how to solve this problem?
Jul 27, 2011 02:54 AM|ayyappan.CNN|LINK
Hi, easy.... press Ctrl + 1 keys in excel cell to find Number Tab, to change the format which evr want... Tyr...
Jul 27, 2011 02:57 AM|ayyappan.CNN|LINK
When you enter data into a cell in Excel, it is handled differently depending on what type of formatting you have assigned to the cell. For example, if you choose Currency formatting, Excel will automatically convert 3 into $3.00; if you choose Date formatting,
Excel would convert 3/1 to March 1, 2002; and if you choose Percent formatting, Excel would change 0.3 to 30%.
All of these choices are available when you highlight/select the cell(s) you want to format, then go to the Format menu and choose Cells, then click on the Number tab in the Format Cells dialog box. There is also a choice named Special and
when you choose that, you can select formats like Social Security Number, Phone Number, etc.
But, what if you want a format that is not included in Excel's pre-made formats? Well, you can make your own custom format, following the directions below.
This should give you a good starting point for understanding Custom formats. Remember that you can apply these formats to cells that already have data in them and Excel will convert the existing data to the new format. Or, you can highlight a range of cells
and apply the format to them before you add the data, then Excel will convert what you type into the new format.
If you want to learn more about how Excel handles formatting, etc., check out my online classes and downloadable ebooks here:
Jul 27, 2011 03:04 AM|princeG|LINK
Check asp.net Thread: http://forums.asp.net/t/1492222.aspx/1