ExcelBanter - excel changes a number to a date and i don't want it to

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

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

- - excel changes a number to a date and i don't want it to (https://www.excelbanter.com/excel-discussion-misc-queries/99867-excel-changes-number-date-i-dont-want.html)

bobmcgod

excel changes a number to a date and i don't want it to

I put 4 - 6 in a cell and it automatical changes it to 04 jun and i don't
want it to. How do i turn this function off?

JE McGimpsey

excel changes a number to a date and i don't want it to

Either preformat the cell as text, or prefix the entry with an
apostrophe (')

In article ,
bobmcgod wrote:

I put 4 - 6 in a cell and it automatical changes it to 04 jun and i don't
want it to. How do i turn this function off?

Special-K

excel changes a number to a date and i don't want it to

Select the cell. Then on the menu select Format / Cells and pick
General.

--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562456

All times are GMT +1. The time now is 06:02 AM.