| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why are my formulas being replaced with values in excel?
I am building a form for users to use to submit data. Part of the data
needed is Lat/Longs. Some of the users use decimal degrees (preferred) and others use degrees, minutes, seconds. Using Userforms in Visual Basics, I have created a form on which they can enter either format. In the decimal degrees cell, I have the formula =((C1/60)+B1)/60+A1. In this formula, A1 = degrees, B1 = Minutes, & C1 = Seconds. However, when a value is entered in A1, B1 or C1, excel overwrites my formula and replaces it with the value. I've never seen it where the formula is replaced by a value. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Null values need to be replaced | Excel Discussion (Misc queries) | |||
| Excel Replaced my work with a google ad .... | Excel Discussion (Misc queries) | |||
| How can I show values, not formulas in Excel? | Excel Discussion (Misc queries) | |||
| how do you find a excel spreadsheet that you replaced with a new | Excel Worksheet Functions | |||
| display values of formulas in Excel | Excel Worksheet Functions | |||
Threaded Mode
