| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
"rlrlatr35" wrote...
I'm taking an excel class & the ? is "if you enter 5B21C2 in cell B1 of a worksheet the formula is replaced by the # 125 when you press enter. What happened? The worksheet is hypethetical. Then the next ? is to use same worksheet, change the # in cell B2 from 55 to 65. What happens to the # in cell B1 & why. The info I found doesn't tell how to figure the first formula so everything else doesn't make sense to me. HELP! I suppose 5B21C2 could be an Islamic calendar date, and 125 it's representation in General number format. That's all I can think of. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| I cant seem to figure out how to use Proper in excel. The help op. | Excel Discussion (Misc queries) | |||
| Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
| Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
Threaded Mode
