| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cells
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 "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
| How do I format cells to show date in Australian not US format? | Excel Worksheet Functions | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Linear Mode
