Keeps getting Date format! Excel

September 9, 2011 at 00:18:27
Specs: Windows 7
Hi, I typed 7-12 and when i press enter, it keeps appearing Dec-7. I dont want the date. i just want 7-12. I have selected "general" formatting but it still jumps back to custom "date" format. Help!

See More: Keeps getting Date format! Excel

Report •

September 9, 2011 at 03:50:57
Start your string with an apostrophe and Excel will accept it as text. The apostrophe will not appear in the cell.

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

Report •

September 10, 2011 at 22:18:46
That awesome!!! Thank you so much!!! ^^

Report •

Related Solutions

Ask Question