format number to date
Try forcing it to a date by changing the
=B1&"/"&C1&"/20"&"A1
to
=--(B1&"/"&C1&"/20"&"A1)
which should work if your Windows Regional Settings (in Control Panel) are
looking for MDY format.
--
David Biddulph
Picodillo wrote:
When I run a query from work and post the information in Excel, the
date shows an odd format. For instance, for July 20, 2009, the date
would read 1090720. I would like to format this into a date that is
recognized by Excel. I am able to spread the data out using "text to
columns" and then using =B1&"/"&C1&"/20"&"A1 so that it looks like
7/20/2009, but Excel doesn't recognize this as a date so I can't do
any conditional formatting. Please help.
|