| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formats
Two choices:
Either precede your entry with an apostrophe '. The apostrophe will not show in the cell, only the formula bar. Or give the cell the number format of Text HTH Kostis Vezerides On Jul 2, 8:21 pm, ej wrote: I have been trying to enter 01-63 as an exaple and it always changes it into a date like jan-63. I have tried everything i can think of to fix it. Any suggestions please let me know |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| Too many cell formats | Excel Discussion (Misc queries) | |||
| Copy and link formats from cell to cell | Excel Discussion (Misc queries) | |||
| Too many Cell Formats | Excel Discussion (Misc queries) | |||
| Cell formats | Excel Worksheet Functions | |||
Threaded Mode
