|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
I want to take a date 2006/02/10 & break it into separate colu
Thank you very much!
cd
"Bernard Liengme" wrote:
Assuming the values are real dates formatted as yyyy/mm/dd:
use =YEAR(A1) = MONTH(A1) and =DAY(A1)
But if the entries are text:
=--LEFT(A1,2) , =--MID(A1,6,2), =--RIGHT(A1,2)
The double negation (that's the two signs after =) will convert text to
numbers.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Curtis" wrote in message
...
|