Dates in cells

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have formatted a cell for dates. When I enter a date it will put a = sign
in font of the date and will not display the correct date. it displays 1/0/00
as the date. How do I get raid of the = sign.
 
Tools > Options Transition uncheck both Transition formula evanuation and
Transition formula entry

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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 VBA to go to specific sheet & cell in the current workbook not working. 2
Date/Time 1
date & Time 1
countifs Function not giving desired result with date criteria 2
Excel Import Comments 3
separating date and time 5
Calculate elapsed time excluding specific timeframe 10
Please help! date showing as 1900/01/00 2

Back
Top