Assitance with Format Cell

[bootj1234]

The following number is formatted as "GENERAL": 2019-03-06T06:47:06. When I remove the T character and replace it with a space. It changes the number format to "CUSTOM" and now the number looks like this 3/6/2019 6:47:06. What can I do to get keep the number with the "GENERAL" format once I remove the "T" and replace it with the space?

Thanks for the help.

-John

 

[MARK858]

Is formatting the cell as Text an option?

 

[Scott T]

Try putting a ' in front to force excel to treat it as text

'2019-03-06 06:47:06