ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date (https://www.excelbanter.com/excel-worksheet-functions/176731-date.html)

Mike[_6_]

Date
 
When I enter a date into a cell it always adds an = sign in front of the
date. Is there an option to stop this from happening?

Sandy Mann

Date
 
See my answer in the misc group. Please do not multipost it causes people
to work on solutions that have already been answered.

See:

http://www.cpearson.com/excel/newposte.htm

--
Regards,


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 it always adds an = sign in front of the
date. Is there an option to stop this from happening?





All times are GMT +1. The time now is 05:47 PM.

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