format number to date
Extra " from the formula OP posted..
If this post helps click Yes
---------------
Jacob Skaria
"T. Valko" wrote:
=--(B1&"/"&C1&"/20"&"A1)
Think there's an extraneous " in there.
=--(B1&"/"&C1&"/20"&A1)
--
Biff
Microsoft Excel MVP
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
|