ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date (https://www.excelbanter.com/excel-discussion-misc-queries/176703-date.html)

Mike[_6_]

Date
 
When I enter a date into a cell, excel adds an = sign in front of the date.
How do I stop this from happening?

Sandy Mann

Date
 
Tools Options Transition and uncheck Transition Formula Entry ( and any
other Transition option that is checked).

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Mike" wrote in message
...
When I enter a date into a cell, excel adds an = sign in front of the
date.
How do I stop this from happening?





All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com