forcing date to excel

D

Daniel

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

VBA - exporting serial letters to single documents 0
Excel does not accept text format! 0
SUMIF with criteria "<>" & "=" 4
Show value from one cell in another cell if today falls between a date range 5
Excel - Wich Function should I use? 1
Formula for converting xx/xx/xxxx dates to a number between 1 and 2
Spurious Formula Omits Adjacent Cells 2
Formula Result is different from the shown result 2

Top