Numbers and Dates in the same column

Bill · 07/19/19

Is there a way to have numbers and dates in the same column? When entering a number less than 100 in a Date column I get a date. When entering a date in a number column I get an error. Is there any way around either of these? I need the numbers and dates in the same column for formatting reasons.

Andrée Starå · 07/19/19

Hi Bill,

You could add punctuation before and then it would work.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Bill · 08/02/19

That works great. Thank you!

Andrée Starå · 08/02/19

Excellent!

Happy to help!

Numbers and Dates in the same column

Comments

Categories