Re: Formatting cells
From: **{Steven}** (none_at_myisp.com)
Date: 03/13/04
- Next message: **{Steven}**: "Print areas"
- Previous message: Dave Peterson: "Re: Adding a column that has format"
- In reply to: patti: "Re: Formatting cells"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 13 Mar 2004 12:45:46 -0500
The way I have mine set up is cells that you enter infomation into and that
places the info in the area that will actually be printed. The printed area
is a form. That way, they cannot mess with the form or change the formulae
and the entry cells show 0 when empty, while the form cells show nothing.
"patti" <pminotti@msn.com> wrote in message
news:ON$MilPCEHA.580@TK2MSFTNGP11.phx.gbl...
> this is cool, I have all kinds of spreadsheets at work this would be great
> for. Are there any limitations or problems I should watch out for?
>
> --
>
> Have the bestest day ever!!
> patti
>
>
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:uzC%23tkFCEHA.1456@TK2MSFTNGP09.phx.gbl...
> > Hi Steven
> > try the custom format
> > 0.00;-0.00;
> >
> > --
> > Regards
> > Frank Kabel
> > Frankfurt, Germany
> >
> > **{Steven}** wrote:
> > > Is there a way to dual format a cell? I have a *** that uses
> > > monetary values, so it is formatted to show 2 decimal places. I also
> > > want to format them, so that if the value is zero, nothing shows. Can
> > > I do that and if so, how?
> > >
> > > TIA
> > >
> > > Steven Connor
> >
>
>
- Next message: **{Steven}**: "Print areas"
- Previous message: Dave Peterson: "Re: Adding a column that has format"
- In reply to: patti: "Re: Formatting cells"
- Messages sorted by: [ date ] [ thread ]
