| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format
Hi there,
I'm updating my excel sheet data from ASP. I've a date field. After updating from Excel Sheet, the cell format changes into a number( I thing dateserial number) eventhough I formatted the cell to accept date. I want to show the date in the excel sheet, I used CDate also & my reginal seeting also correct. Pls help me to sort this. Regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Format
Kavi;
Use the following on the menu: Format | Cells Then on the category tab choose "Date" or "Custom" to choose a format or create your own. Does it help ? Mark Rosenkrantz. More Excel ? www.rosenkrantz.nl or ---------------------------------------------------------------- "Kavi" wrote in message ... Hi there, I'm updating my excel sheet data from ASP. I've a date field. After updating from Excel Sheet, the cell format changes into a number( I thing dateserial number) eventhough I formatted the cell to accept date. I want to show the date in the excel sheet, I used CDate also & my reginal seeting also correct. Pls help me to sort this. Regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
![Kavi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
