Help With Excel 2007

[krishnandu.sarkar]

Hi frndz........When I type 2/14 in any cell it gets automatically converted to 14-Feb. What shud I do to stop this???

No Auto-Formatting pop up is coming from which I may revert the change. I also tried to stop auto-formatting. But no results. Pls help. I need to submit ths excel document to coll 2moro. Plz help ASAP.


Thnx in advance

 

[pillainp]

Type it in like this:

`2/14

The ` is the leftmost of the number keys : ~/`

Whatever is entered in a cell with the apostrophe is front of it will automatically be treated as text.

 

[krishnandu.sarkar]

thnx........!!

I found another way......

Well b4 writing nythng 2 cell If I convert it to text.......it doesn't get changed....!!!

 

[pillainp]

That is the other way.

Good to see you got it solved.

 

[krdalmia]

I have another problem.
I am not getting the small square at the bottom right hand corner of selected cell. As a result most of the guys in my family are not able to click on it and copy the contents or formula in the cells below. Plz help.

 

[pillainp]

I have another problem.
I am not getting the small square at the bottom right hand corner of selected cell. As a result most of the guys in my family are not able to click on it and copy the contents or formula in the cells below. Plz help.

Look at the attached picture. That option should have be checked to enable drag fill. You can find it Excel Options (Orb>Excel Options) on the Advanced page.

*i25.tinypic.com/il8zf7.jpg