Im in excel and it will not let me type what i need?

J

janet_michelle

I'm in excel and i need to put 1-30 and it automatically puts 30Jan when i go
to the next cell and can i change that?
 
P

Paul B

Janet, format the cell as text first or put a ' in front of it, it want show

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2003
 
D

Dave Peterson

Preformat the cell as text, then type the entry
or
start your entry with an apostrophe: '1-30
 
S

Soundar

Change the format of the cell to Text.

Format -> Number - > Text (From category)

Hope this will clear your doubt.

Regards,
Soundar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have a document with 8 different templates on it. 1
fill range with dates based on month 0
Word macro that can call cells out of Excel for a find and replace 0
Need Help with Macro Security 1
Merging from an Excel file with graphics 1
Excel - Wich Function should I use? 1
Excel --> Word 4
Setting a default zoom in Infopath 0

Top