Problem copying date

[schallpattern]

Hi,

I've got the date picker embedded in a cell giving the correct/current date (in A1) - all good. I want to export the date to another cell but when I do '=A1', it gives me a return of 00/01/1900

How can I get it to give me the date entered?

Many thanks,

Schall

 

[oldbrewer]

in A1 put =today() maybe

 

[schallpattern]

No, that just returns the current date, not my recorded date. Thanks, though.

 

[Fluff]

If you format A1 as text, what do you see?

 

[schallpattern]

It just returns a value of 0.

 

[oldbrewer]

[TABLE="width: 334"]
<colgroup><col span="2"><col span="3"></colgroup><tbody>[TR]
[TD="align: right"]07/10/2017[/TD]
[TD="align: right"]07/10/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]in A1 I typed the date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]in B1 I put =A1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]so I am not sure what your problem is[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]is A1 a drop down list of dates ?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

It just returns a value of 0.

In that case the value is not a date. If you had today's date in A1 9/11/2017 & formatted as text you'd see 43048.