| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
forcing date to excel
Hi
I wrote a query in sql and export to excel. To make sure user can see the date I use the convert() function to column A. The problem is at other corner of excel a cell B1 referenced to column A can not convert to serial number with formula ="=" &A1 My question: What is the date format so B1 can have the serial number with above formula? Thanks Daniel |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
forcing date to excel
Exactly what is in column A1?
"Daniel" wrote in message ... Hi I wrote a query in sql and export to excel. To make sure user can see the date I use the convert() function to column A. The problem is at other corner of excel a cell B1 referenced to column A can not convert to serial number with formula ="=" &A1 My question: What is the date format so B1 can have the serial number with above formula? Thanks Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forcing Excel to retain red text? | Excel Discussion (Misc queries) | |||
| Forcing english date format | Excel Worksheet Functions | |||
| Forcing a specific date format | New Users to Excel | |||
| Forcing Excel to Load Below Office Toolbar | Excel Discussion (Misc queries) | |||
| Forcing an Excel spreadsheet to print only selected groups of cel. | Excel Worksheet Functions | |||
Linear Mode
