ExcelBanter - Excel -

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

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

- - Excel - (https://www.excelbanter.com/excel-discussion-misc-queries/248529-excel.html)

Balgaran

Excel -

I put a number, say 2, in a cell & move to other cell. The number changes
and becomes a date, 'Jan-00' . Why and how do I stop this occuring????

Jacob Skaria

Excel -

Format the cells to 'General' . Right clickFormat CellsFrom 'Number' tab
select 'General'

"Balgaran" wrote:

I put a number, say 2, in a cell & move to other cell. The number changes
and becomes a date, 'Jan-00' . Why and how do I stop this occuring????

All times are GMT +1. The time now is 06:14 PM.