ExcelBanter - dates

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

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

- - dates (https://www.excelbanter.com/excel-discussion-misc-queries/172374-dates.html)

raiderrob1977-1

dates

how do i get excel from turning this number 2-2100 in to Feb-00?

MartinW

dates

Hi Rob,

Precede it with an apostrophe like this '2-2100
The apostrophe will show in the formula
bar but not in the cell..

or preformat the cell as text.

HTH
Martin

"raiderrob1977-1" wrote in
message ...
how do i get excel from turning this number 2-2100 in to Feb-00?

All times are GMT +1. The time now is 05:10 AM.