ExcelBanter - cells

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

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

- - cells (https://www.excelbanter.com/excel-discussion-misc-queries/188858-cells.html)

blabla

cells

im looking howto just type in over 8 digits in a cell without it
calculating,can anyone help please ,

GTVT06

cells

On May 26, 10:25*am, blabla wrote:
im looking howto just type in over 8 digits in a cell without it
calculating,can anyone help please ,

can you store it as text? if so you can add a ' in front of the digits
i.e. '12345678

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