Re: $ sign formats
- From: utahbiker7 <utahbiker7@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 23 Jul 2008 10:48:02 -0700
Rick,
I'm using a pre-made template that is used each day. The spread sheet is
designed with several columns and breaks for each vendor. I enter the data
each day for the vendors and then print out to the forms. The vendor may
have 10 line items for one day where as maybe only 1 or 2 line items entered
the next day. Because the template has all 10 lines formated, I must erase
(I put a tick mark in the non-value fields) the remaining lines so the $ sign
(on my screen it shows and prints "$ -" for the cells with no amounts
entered) doesn't show. When I used Lotus, all I had to do was check a field
do not show format if no value was entered. In Excel I don't see this
option. I was wondering if there was a way to turn the formats off for the
cells that do not have dollar values entered? This is my question.
"Rick Rothstein (MVP - VB)" wrote:
How is the $ sign being inserted now? If you cells just contain numbers and.
if you then Format Cells as currency, the $ sign will not show up on blank
cells automatically. Also, what is that - (dash, minus sign) there for?
Rick
"utahbiker7" <utahbiker7@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:601EBE33-F4F9-45C8-94EC-DE9C64270972@xxxxxxxxxxxxxxxx
How to you remove the dollar "$ - " formats from each cell that doesn't
have a value entered? If there is no value in the cell, I want the
format
"$ -" to not show otherwise they will print on my forms all these $
signs.
I remember in Lotus that it was easy to tell the spreadsheet to ignore the
format if no value was entered. I can not figure out how to do this in
Excel.
Any help would be greatly appreciated.
Thanks
- References:
- Re: $ sign formats
- From: Rick Rothstein \(MVP - VB\)
- Re: $ sign formats
- Prev by Date: Re: Grid Line
- Next by Date: RE: Lookup Formula - I think?
- Previous by thread: Re: $ sign formats
- Next by thread: Re: $ sign formats
- Index(es):
Relevant Pages
|
