Excel Inserting "=" when entering date

  • Thread starter Thread starter simeyg
  • Start date Start date
S

simeyg

can anybody tell me when my excel workbook is inserting a "=" when
enter a date. instead of just the date. when i enter a normal numbe
the "=" is not inserted

i think this is a settings problem but i cant see how to change it

Simo
 
Hi Simon!

This is a setting that you can deactivate.

In Excel, click on the Tools menu, then click on Options, select the
Transition tab and unselect "Transition formula entry".


Best regards

Stefan Hägglund
Microsoft
 
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

Default number format in Excel 1
Default date format 4
How to enter start and end date/time in excel based on some specific value. 7
Coding drop down list results as numbers 1
Date recalculates 1
Protected Sheet and grouping 1
Auto Input Today's Date 3
excel Cell issue 2

Back
Top