cell automatically changing format

Y

YESHWANT JOSHI

in excel 2000, i have a column formatted as general. if i edit the same, do
or does not chage the value of the cell, and press enter it automatically get
changed to "MM/DD/YYYY" format . what could be the reason and remedy for
the same. thanx in advance
 
M

Mike H

Hi,

That sounds like Excel trying to be helpful, if you enter something that
looks like a date then Excel will format it as a date. Try entering a ' in
the cell before you enter your values, it won't show in the cell.

Mike
 
Y

YESHWANT JOSHI

all those cell contains formulas and so putting ' in the beginning will not
solve my problem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Numbers change to a date format 4
Incorrect date value when open DBF file in Excel 0
Date automatically swaps 3
date 1
Date Format 10
Stop XL from changing format? 1
International Date formatting 6

Top