Dates in cells
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. |
Dates in cells
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 Replace @mailinator.com with @tiscali.co.uk "Mike" wrote in message ... 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. |
All times are GMT +1. The time now is 04:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com