Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
Cells with dates... | Excel Worksheet Functions | |||
Cells with a value between two dates | Excel Worksheet Functions |