A Free Newsletter for Users of the HP95LX/100LX/200LX
In this issue: Spreadsheet Tips and Tricks
---Entering Stock Prices in Lotus 1-2-3
---New Toy on the Horizon
---Save a Keystroke or Two in 1-2-3
Like your palmtop? Why not the ultimate? We have fewer than100 new doublespeed 200LXs with from 8 to 96 Megabytes of C drive space. When these Palmtops are gone, they are gone. The units are available at http://www.PalmtopPaper.com.
Entering Stock Prices in Lotus 1-2-3
Stock prices are typically given in terms of whole dollar amounts and a fraction, e.g., 61 5/16.
To enter the value in Lotus 1-2-3, you could key in 61+5/16 and press Enter. The value 61.3125 would appear in the target cell.
Here's another way to do the same thing. The advantage is that you can always see the fractional amount and the decimal equivalent.
Here's how to do this.
In a blank worksheet, press MENU Range Format Currency 0 and press Enter. Set the range to A1..A20 and press Enter. Use MENU Range Format Text, press Enter and set the range as B1..B20.
In cell C1 enter the formula +A1+B1 and then use MENU Copy A1 to A2..A20.
To enter stock values, just put the whole dollar amount in column A and the fractional amount in the B column. The decimal equivalent will appear in the cell in column C.
The trick involves setting column B to Text format. It might seem that you're adding a number to "text" but that isn't the case. In Lotus-speak, "text" means "view the underlying formula as a label rather than as a number."
This seldom used formatting command (MENU Range Format Text) comes in handy when debugging a worksheet. With a couple of macros you can toggle the text and value display of a range of cells. To see how this might work, enter the following macros in cells E2 and E4:
'/RFF2~B1..B20~ and '/RFTB1..B20~
Use the command MENU Range Name Create \N and assign the range name to cell E2. Use MENU Range Name Create \F and assign the range name to cell E4. When you press ALT+F and ALT+N you'll toggle the display of values in the range B1..B20.
We can repair your palmtop at a reasonable price. Broken display? Cracked Hinge? Busted serial pins? One price fixes all. Why not upgrade your machine at the same time. It's like getting a new machine.
New Toy on the Horizon
Are you a "gadget junkie" who likes to know what's coming next? Here's one that made my eyes pop. It's a Linux version of the palm sized, WinCE machines. The specifications are amazing. To see for yourself what Samsung has on the drawing boards, point your Web browser at.
Save a Keystroke or Two in 1-2-3
The usual way to copy a cell in 1-2-3 involves a lot of scrolling and losing your place. Here's a time-honored tip to avoid the nuisance features.
Say you want to copy the value in cell A1 to cell Z30 and have the cursor positioned in cell Z30 at the end of the operation. Do the following. Press F5(Goto) Z30 and press Enter. Use the command MENU Copy A1 Enter Enter. That's it.
Sell us 1 or 1000 palmtops even if they are broken. See
How about Windows CE? Visit http://www.hpcmag.com