ExcelBanter - Answer to 2/29 gets converted to 2/1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Answer to 2/29 gets converted to 2/1 (https://www.excelbanter.com/excel-discussion-misc-queries/78719-re-answer-2-29-gets-converted-2-1-a.html)

Gary''s Student

Answer to 2/29 gets converted to 2/1

enter 0 2/29
the single space after the zero is necessary
--
Gary's Student

"Barb Reinhardt" wrote:

When I enter just 2/29 into a cell in excel, the resulting value is 2/1/2029.
I'm wondering if that's what you are seeing.

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