Assitance with Format Cell

bootj1234

Board Regular
Joined
Aug 27, 2012
Messages
85
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,628
Office Version
365, 2010
Platform
Windows, Mobile
Is formatting the cell as Text an option?
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,611
Office Version
365, 2016
Platform
Windows
Try putting a ' in front to force excel to treat it as text
Code:
'2019-03-06 06:47:06
 

Watch MrExcel Video

Forum statistics

Threads
1,099,006
Messages
5,465,968
Members
406,457
Latest member
Pinky Rose Jordan

This Week's Hot Topics

Top