Re: Formatting Cells..

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

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 *** here where I can type 0 and it automatically fills
in $0.00. That is for sending customer samples. The sales rep XLS *** 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


.