Cell Format changing problem

[sabarish]

I am Using Windows XP OS 32 Bit and MS Excel 2007.

Need help to fix this problem it should be any settings or <acronym title="visual basic for applications">VBA</acronym> codings.

-- removed inline image ---

​

1. Please see this screenshot image, in this image the marked QTY contains only numerical value(NUMBER-GENERAL) but it showing in date format.
2. Another cells marked contains AUG-13.... its also contains only numerical value but it showing in date format which is marked.
3. Please help to fix this issue

 

[Zyg D]

Any shorter way to show a picture? My browser cannot read it !

Request-URI Too Large
The requested URL's length exceeds the capacity limit for this server.

 

[sabarish]

Dear Experts,

How to show a screen shot for a problem in easier way..

Kindly help me...