Lost Date Format

  • Thread starter Thread starter Growing
  • Start date Start date
G

Growing

Hello.

I copied Worksheet 1 to worksheet2 and lost my date formats. The date
is now showing as the General format (36821) instead of mm/dd/yy. I
tried to change the the cell in the Format option, but that did not
work for me.
Any ideas.

Thanks
 
Do you see the date in the formula bar?

If yes, maybe this will work:

tools|Options|view|uncheck formulas

There's a shortcut key, too.
ctrl-` (control-backquote, backquote is to the left of the 1/! key on my USA
keyboard).
 
You must log in or register to reply here.

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

How to enter a date in DD-MM-YYYY format 2
Date Format Problem. 2
date format convert 2
date format problem 4
Date Format 3
yet another date format problem 1
Ref a file in date format 2
In Excell-2000 where do I set format for date? 5

Back
Top