Hi all,
I have a cell,let's say F1,where users can input the date formatted
mm/dd/yyyy,i need that G1 automatically views the part mm/yyyy extracted from
F1.
Can anybody help ?!

=F1 and format as mm/yyyy ?

Or, of course, you can format F1 as mm/yyyy, input the data as mm/dd/yyyy,
and then you wouldn't need G1.
--
David Biddulph

"Pietro" wrote in message
...
Hi all,
I have a cell,let's say F1,where users can input the date formatted
mm/dd/yyyy,i need that G1 automatically views the part mm/yyyy extracted
from
F1.
Can anybody help ?!

Try =TEXT(F1,"mm/yyyy")

Sandy

"Pietro" wrote in message
...
Hi all,
I have a cell,let's say F1,where users can input the date formatted
mm/dd/yyyy,i need that G1 automatically views the part mm/yyyy extracted
from
F1.
Can anybody help ?!