Date format changes when inserting rows

F

falcios

I selected a column and formatted it so that the date displays ex. 3/12/09.
When I insert rows and type in the date it displays as 3/12/2009. Why does
the format change? How can I get it so I don't have to format the dates
individually or reformat the whole column.

Thanks.
 
S

Shane Devenshire

Hi,

I can't duplicate your problem in 2003.

If I have dates formatted to 1/13/09 in A1:A10 and then right-click row
number 5 and choose Insert, when I type a new date into the blank cell A5, is
goes in as 1/13/09. By the way Insert, Copied Cells in not equivalent to
Insert Row.

Better give us more details. What version, how are you doing the insert?
 

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

Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Date Format not working 2
INSERTING NEW ROWS 3
Conditional Formats Date Based 1
retain custom date format "text" when pasting or reformatting data 2
Remove date format? 3
Insert 3 blank rows wherever the date changes in column???? 8
date format 1

Top