Home |
Search |
Today's Posts |
#1
|
|||
|
|||
number changes into date-but I do not want it
when I type in the pH value of let's say 11.2 it changes into date like
nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!! |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Most unusual.
Normal pattern for 11-2 but not 11.2 Try formatting the cells to General. What is the date separator set for in your WindowsControl PanelRegional and Language OptionsGeneralCustomDate? Maybe change it from a decimal point to a slash / or - Gord Dibben Excel MVP On Tue, 15 Mar 2005 15:51:01 -0800, wrote: when I type in the pH value of let's say 11.2 it changes into date like nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want to add a number to a date and get the date as an answer eg. | Excel Worksheet Functions | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) |