| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Another of Excel's idiosyncrasis
In the formula "=ROUND(Data!G242*0.975*0.5*0.975,0)", if I need to do an
edit, replace to eliminate the portion "*.975,0)" and replace that with ",0)", Excel insists on screwing up the whole formula and resulting cell entry is ",0)" This is so stupid of Excel to do it that way, when I am only wanting a portion replaced. How do I get around this most inconvenient indiosyncracy of Excel in this case? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel's Fourier Analysis should be a function, so that results upd | Excel Worksheet Functions | |||
| Getting Excel's charting capabilities from Access | Excel Discussion (Misc queries) | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
| Excel's Dialog Box | Excel Discussion (Misc queries) | |||
| Excel's column width format box | New Users to Excel | |||
Threaded Mode
