Thread: format cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default format cells

You forgot the equal sign

=1/5233

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

'1/5233

"tazgirl1025" wrote:

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