format cells

T

tazgirl1025

I am trying to type the following in a cell and I want the format as general,
but when I type it in, it automatically changes to date format

1/5233


can anyone help
 
J

Joel

You forgot the equal sign

=1/5233

Or if you want text then put a single quote in front of the string

'1/5233
 
C

Cheers,

Hi,

Excel is recognizing this as January 5233! You can preformat the cell to
Number or Text to avoid this, but be careful if you choose Number Excel will
divide 1 by 5233 and give you .0001910949....
If you choose TEXT then it will be displayed as 1/5233

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Format date in a cell 2
Cell Format 1
Remove date format? 3
How to remove the automatic date format? 3
Auto Cell Format Change from General to Custom Date 1
Office 2007 + formatting cells 1
Numbers change in cell even when formatted as text 4
paste web without date format 1

Top