Can anyone help me with the following issue. In cel1 A1 I have a date
4/3/2008. In cell B1 I want to show 4/3/2008 as Apr08 or Apr2008. I am
using =month (A1)&Year(A1) and the result is 42008. Can anyone help me
revise the formula so that it will show the month as text and preferrably a 2
yr date Apr08?
--
Thanks, Annie

Hi Annie

Format B1 as Date to display the result as a date.

Or

let the formula in B1 be =A1
Select B1 and goto Format Format Cells Number Custom In the Type:
field enter mmmyy OK

Hopes this helps

---
Per

"Annie" skrev i meddelelsen
...
Can anyone help me with the following issue. In cel1 A1 I have a date
4/3/2008. In cell B1 I want to show 4/3/2008 as Apr08 or Apr2008. I am
using =month (A1)&Year(A1) and the result is 42008. Can anyone help me
revise the formula so that it will show the month as text and preferrably
a 2
yr date Apr08?
--
Thanks, Annie

Try this:

=TEXT(A1,"mmmyy")

--
Biff
Microsoft Excel MVP


"Annie" wrote in message
...
Can anyone help me with the following issue. In cel1 A1 I have a date
4/3/2008. In cell B1 I want to show 4/3/2008 as Apr08 or Apr2008. I am
using =month (A1)&Year(A1) and the result is 42008. Can anyone help me
revise the formula so that it will show the month as text and preferrably
a 2
yr date Apr08?
--
Thanks, Annie