Date formatting

M

Melissa

I need to know if there is a way to display the date as a mmy -

like for 12/1/2005 I need to look like this 125

It's for a form I'm working on - I changed the date format to mmy - and it
automatically shows as 1205

Any ideas?
Melissa
 
M

Marcelo

hi Melissa,

one way, assuming your data is on G6 cell

=month(g6¨)&right(year(g6),1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Melissa" escreveu:
 
M

Marcelo

=month(g6)&right(year(g6),1)

sorry for the ´´


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:
 
Top