Change Date to plain text

[nt82]

Hi..I have a cell in excel which has date '20180907' and when i click the cell it shows 9/7/2018.

I would like to convert this cell to plain text and remove the date so it stays as '20180907' and not the date.

thanks in advance.

 

[Special-K99]

=TEXT(A1,"yyyymmdd")

 

[Joe4]

Then it sounds like what you currently have is a valid date with a Custom Format of something like "YYYYMMDD" or "YYYYDDMM"
(I cannot tell from your example whether Month or Day comes first - it depends on whether you are using an American or European version of Excel, so adjust the formulas below accordingly).

A formula to return the value of A1 to text would look like:

=TEXT(A1,"YYYYMMDD")

In VBA, it would look something like:

FORMAT(RANGE("A1"),"YYYYMMDD")