Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formats
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formats
formatt the cells (or columns) you will be entering the data into as 'text'
before you start entering data. "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formats
Enter it with an apostrophe in front, i.e.
'01-63 and Excel will take this as a text value (the apostrophe will not show in the cell). Alternatively, pre-format the cell as Text beforehand, and then you can enter it as 01-63. Hope this helps. Pete On Jul 2, 6: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 |
#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 |
Reply |
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 |