Custom Format-- date question

[araymc]

I need to take

9/10/1995

and custom format to appear as

S101995

I can't figure out how to on my custom formatting.

Anyone?

Thanks...
Anita

 

[araymc]

Thanks Rick! I will certainly test each method of this type when back @ the office tomorrow.

Since I'm new to the board, I hope all will pardon my elementary questions.

I love Excel and while my knowledge is little, I learn rather quickly...though sometimes I can be thick-headed. I have a lot at stake with my job and will probably resort to this board as often as needed.

Good thing I like to learn!

Anita

 

[Haseeb Avarakkan]

Hello Anita,

If you are using "S" for September, How you can identify for month Jan, Jun & Jul? and March, May?

This will be as J for Jan, Jun & Jul, M for Mar & May. If that is not a matter you can also use a custom cell format.

Right Click >> Format Cell >> Custom;

mmmmmdyyyy

Note: There are 5 m.

A formula option is;

=TEXT(A1,"mmmmmdyyyy")

 

[Rick Rothstein]

This will be as J for Jan, Jun & Jul, M for Mar & May. If that is not a matter you can also use a custom cell format.

Right Click >> Format Cell >> Custom;

mmmmmdyyyy

Note: There are 5 m.

A formula option is;

=TEXT(A1,"mmmmmdyyyy")

Hmm... 5 m's returns the first letter of the month name... good to know.

 

[araymc]

OOO....Haseeb! That is good to know and the J being for multiple months is no problem for the end result. I will give this a whirl and save for future reference.

I appreciate everyone of you who helped me!

Anita