format cells

  • Thread starter Thread starter tazgirl1025
  • Start date Start date
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
 
You forgot the equal sign

=1/5233

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

'1/5233
 
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
 
You must log in or register to reply here.

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

Creating Columns from space delimited list 2
Remove date format? 3
Conditional formatting in Excel 2010 2
Cell Format 1
Entering 'GTi' but I get 'Gti' ! 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Auto Cell Format Change from General to Custom Date 1
Format date in a cell 2

Back
Top