Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!ukc!stl!ndh From: ndh@stl.stc.co.uk (Neale D Hind ) Newsgroups: comp.os.msdos.apps Subject: Re: Lotus 1-2-3 question: left-justified dollar signs? Message-ID: <4353@stl.stc.co.uk> Date: 26 Apr 91 12:44:31 GMT References: <12998@pasteur.Berkeley.EDU> Sender: news@stl.stc.co.uk Reply-To: "Neale D Hind " Organization: BNR Europe Limited, London Road, Harlow, Essex, UK Lines: 24 In the referenced article sadoyama@argon.berkeley.edu (Eric Sadoyama) writes: >It's annual budget time again, and this year I've resolved to find this out: >how do I get the dollar signs in my 1-2-3 spreadsheet to line up on the left >hand side of the column? > The easy way: ------------- 1: Format your cells as comma (NOT currency) format. 2: Insert a column (of width 1) to the left of all cells that you want to precede with a dollar sign 3: Enter dollar signs (as labels) into the new column next to every number. The hard way: ------------- Do lots of clever string manipulation and character counting code surrounding every formula/value +----------------------------------------------------------------+ | Neale D. Hind | Email: ndh@stl.stc.co.uk | | Manager, Financial Planning | Phone: +44 279 429531 x3613 | | BNR Europe Limited | Fax : +44 279 441551 | | London Road, HARLOW | ITN : 782-3613 | | Essex CM17 9NA, United Kingdom | Telex: 81151 STL HW G | +----------------------------------------------------------------+