Re: Formatting Cells..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"shawn" <yuppicide138@xxxxxxxxxxxxx> wrote in message
news:Ocrse5%23HIHA.3956@xxxxxxxxxxxxxxxxxxxxxxx
I have an XLS sheet that we use to make invoices for samples we send to our
sales reps. We use the same XLS sheet, but save it renamed on our network
with that customer name and date, just changing the data on the sheet.

On the right hand side are two columns marked Line Price and Extended
Price. Line Price is the price the sales rep pays per sample. Extended
Price is the price they pay total, like if they had ordered more than one
it auto calculates.

Some things we send such as catalogs are free. I want these to show up as
$0.00 but can't figure out how! I can format a cell as currency or number
and it doesn't put anything in there.. just makes it blank. If I format it
as text, then it puts a little error sign in the corner, which drives me
crazy.

I do have one XLS sheet here where I can type 0 and it automatically fills
in $0.00. That is for sending customer samples. The sales rep XLS sheet is
almost the same, the layout is a little different. I can't figure out why
I can't make a cell show $0.00 as a number. Any suggestions?



highlight the column, right-click, chose Format cells, Custom and add a
custom format of $#,###.00


.

Relevant Pages

  • Re: guitar ctr vs. Sam @$$
    ... customer service skills, ... stores in the past, haven't been isolated incidents. ... at our store they don't even bother to put price ... They have these stupid-cheap sales from time to ...
    (rec.music.makers.percussion)
  • Formatting Cells..
    ... I have an XLS sheet that we use to make invoices for samples we send to our ... On the right hand side are two columns marked Line Price and Extended Price. ... Line Price is the price the sales rep pays per sample. ... I can format a cell as currency or number ...
    (microsoft.public.excel)
  • Re: Unique Values Query
    ... Single Query Solution; ... FROM Sales AS ASales ... The fields consist of Customer ... Many of the purchases are for the same item, at the same price; ...
    (microsoft.public.access.queries)
  • Re: How many unique customers has everyone been involved with?
    ... In the Pivot you can count Company quoted by Sales Rep ... for example, Fred has quoted a price (to Builders Inc) for bricks, another ... price for tiles, and another price for concrete, all for the same customer. ...
    (microsoft.public.excel.misc)
  • Re: See what I mean about modern gizmos?
    ... =A0The higher quality goods unsurprisingly cost more ... I know of no manufacturer that specifies the delay on their ... If you were such a discerning customer, ... by differentiating their products from other companies, sice price is ...
    (uk.legal)