Cell Formatting sep11 changes to date

June 16, 2011 at 14:33:19
Specs: Windows 7
Trying to put "sep11" in a cell, keeps changing to date, formatting changes to number. I just want to put "sep11" so frustrating....

See More: Cell Formatting sep11 changes to date

Report •


#1
June 16, 2011 at 14:50:36
First format the cell as TEXT, then enter you sep11 string.

MIKE

http://www.skeptic.com/


Report •

#2
June 16, 2011 at 15:42:19
Put a single quote before your string to force Excel to accept it as text.

The single quote won't be displayed.

'sep11 will display sep11

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
June 20, 2011 at 12:39:56
Thanks mmcconaghy, it worked! Thanks all you guys. Sometimes, it's the simple things.

Report •

Related Solutions


Ask Question