Text to YYYY format
Works like a charm. Thanks
"Rick Rothstein" wrote:
Give this a try...
As text: =TEXT("1/1/" & LEFT(B1,2), "YYYY")
As number: =--TEXT("1/1/" & LEFT(B1,2), "YYYY")
--
Rick (MVP - Excel)
"sojuman" wrote in message
...
I have text in column "B" that is formatted YYANNNNN (01B12345). I would
like to change to YYYY (2001) format in column "A".
Thanks
|