ExcelBanter - cells changing from number to date

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

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

- - cells changing from number to date (https://www.excelbanter.com/excel-discussion-misc-queries/18720-cells-changing-number-date.html)

[email protected]

cells changing from number to date

I am putting a number in a cell, then tabbing to the next cell, the previous
cell changed from a number to a date. How do I keep the number there?

Bob Phillips

What are you inputting, a fraction?if so, format as # ??/??

--

HTH

RP
(remove nothere from the email address if mailing direct)

" wrote in
message ...
I am putting a number in a cell, then tabbing to the next cell, the
previous
cell changed from a number to a date. How do I keep the number there?

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