forcing date to excel

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for converting xx/xx/xxxx dates to a number between 1 and 2
Nameing a function 1
Excel functions 0
date in excel ? 7
Function help required... Between funtion 2
Concantenate which keeps bold of some parts. 5
conditional format help 3
Spurious Formula Omits Adjacent Cells 2

Top