Re: how long date difference
"hellZg8" <hellZg8@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9A93810C-C87D-4EF6-88AF-EBA791254F5A@xxxxxxxxxxxxxxxx
sorry I should had said a Value error
Perhaps your misspelling of February?
And it may not recognise that format. Try something like 18/2/88.
=ISNUMBER(A1) will check that you've got a number that it can understand.
--
David Biddulph
.
Relevant Pages
- Re: date recognition problem
... just by opening and closing TTC. ... and then formatting that column using Format - Cell - Date. ... Excel will recognise the individual D cells as dates if I click the cursor ...
(microsoft.public.excel.worksheet.functions) - Re: Converting 8 digit numbers into dates
... choose ymd for the date format ... You could record a macro when you do this if you needed code. ... doesn't recognise them as a date. ... something that Excel recognises as a UK date. ...
(microsoft.public.excel.misc) - Re: Commas and decimal places to signify decimal point
... > representation of the value to the oracle driver and oracle performs ... > format was nnn,nn. ... > It looks like the database is set up to have just ',' recognised as the ... > Is there any way to recognise both ',' and '.' ...
(comp.databases.oracle.server) - Re: [Full-disclosure] stompy the session stomper - tool availability
... (and that I recognise that WebScarab's analysis is pretty trivial). ... Geee, sorry, I suck for misspelling your name (but feel retroactively ...
(Full-Disclosure) - Re: Hard disk
... > I have just fitted an 80Gb hard disk to my pentium III ... > The BIOS seems to recognise it and the device manager ... And then right click on the Drive in question, choose format (make it NTFS, ... Then give it a drive letter. ...
(microsoft.public.windowsxp.hardware) |
|
