Date Formatting

[birchthecat]

Please help, I am trying to assign a full month to one cell. I can get the cell to show November-05 but when you actually left click on the cell in the formula bar it shows 01/11/2005 I need this to show the full month please help

 

[fairwinds]

Hi,

Then you need to treat is as text e.g. put a single qute before the date:

'November-05

 

[RAM]

Fairwind,

Can you post me an example of that? I'll pick up your answer later.

Thanks

RAM

 

[fairwinds]

Book1
	A	B	C	D
1	November-05
2
3
Sheet1

 

[RAM]

Well, yea, that's an example, but how do you get that with '11/1/05?

 

[fairwinds]

Don't understand what you are after here.

If you have a date in the cell, the formula bar will show the date regardless of how your cell is formatted. If you want the formula bar to show something specific, it must be text.

 

[RAM]

You're right. I was entering it wrong and from there it didn't make any sense anymore.