Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Once a column is marked as $, how do I change it back?
I have a spreadsheet in which one column of data has been and should only be
calendar dates. All of a sudden now, when I type in a date (i.e., 12/1) into this column, it comes out as 12. How can I correct this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Once a column is marked as $, how do I change it back?
try this
Select those cells Go to Format in Menu Bar choose Cells select Custom in Type type in dd/m click ok does this do what you want? Pls click Yes if this help cheers, "wpbvin" wrote: I have a spreadsheet in which one column of data has been and should only be calendar dates. All of a sudden now, when I type in a date (i.e., 12/1) into this column, it comes out as 12. How can I correct this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Once a column is marked as $, how do I change it back?
When you type in 12/3 do you get 4 in the cell?
Might be you have Lotus formula entry enabled. Go to ToolsOptionsTransition and uncheck all options Above location info for 2003 and earlier. Gord Dibben MS Excel MVP On Wed, 3 Dec 2008 11:31:21 -0800, wpbvin wrote: I have a spreadsheet in which one column of data has been and should only be calendar dates. All of a sudden now, when I type in a date (i.e., 12/1) into this column, it comes out as 12. How can I correct this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column labels back to letters? | Excel Discussion (Misc queries) | |||
Somehow column headers changed to #'s, how do you change back? | Excel Worksheet Functions | |||
How can change column title back to alphabet (A,B,C..) | Excel Worksheet Functions | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) |