Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sdd.hp.com!spool.mu.edu!news.cs.indiana.edu!arizona.edu!misvax.mis.arizona.edu!mwilliams
From: mwilliams@misvax.mis.arizona.edu (Michael Williams)
Newsgroups: comp.os.msdos.apps
Subject: Re: Lotus 1-2-3 question: left-justified dollar signs
Message-ID: <26APR91143748@misvax.mis.arizona.edu>
Date: 26 Apr 91 19:37:48 GMT
Article-I.D.: misvax.26APR91143748
References: <12998@pasteur.Berkeley.EDU>
Reply-To: mwilliams@misvax.mis.arizona.edu
Distribution: usa,local
Organization: University of Arizona - MIS Department
Lines: 17
Nntp-Posting-Host: misvax.mis.arizona.edu
News-Software: VAX/VMS VNEWS 1.3-4   Lines: 17

In article <12998@pasteur.Berkeley.EDU>, 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?

I've worked with Lotus 123 and Quattro for a few years and have never been able 
to figure out how to do this--I don't think there is a way :-(.  The only 
options I can think of are to format the top row in the spreadsheet as 
currency and the rows below as commas.  You can also insert a column before 
the numbers and set the width to 1 or 2 and fill this column with dollar 
signs (but I don't think this looks very good).  If anyone does have a good 
method I'd love to hear about it.

Michael Williams               |                  _   /|    Bill Rules!
                               |                  \'o.O'
University of Arizona, MIS     |     ACK! PTHFT!  =(___)=
mwilliams@mis.arizona.edu      |                     U