| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date values are converted to formulas
I am using a workbook created by an associate in which 1 of the worksheets
will not allow a date to be entered other than as a text string. "Normal" entry in a "03/10/306" style is converted into its mathematical formula equivalent and a numercal answer. What can I do to fix this ...beyond copy and paste to another worksheet. Help please! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date values are converted to formulas
Look at ToolsOptionsTransition tab and uncheck any transition options
-- Kind regards, Niek Otten "Al B" wrote in message ... I am using a workbook created by an associate in which 1 of the worksheets will not allow a date to be entered other than as a text string. "Normal" entry in a "03/10/306" style is converted into its mathematical formula equivalent and a numercal answer. What can I do to fix this ...beyond copy and paste to another worksheet. Help please! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute values in formulas | Excel Discussion (Misc queries) | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| vlookup formulas returning no values | Excel Worksheet Functions | |||
| differentiating between formulas and values | Excel Discussion (Misc queries) | |||
| Grabbing recods based on date and shift values | Excel Worksheet Functions | |||
Hybrid Mode
