Formatting Cells..

[shawn]

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?

 

[Gordon]

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

 

[Guest]

Hi Shawn,

Check your options for "Show Zero values" for the worksheet. However, it
might turn them on in other areas where they are not wanted.

Regards,

OssieMac

 

[shawn]

Thanks a bunch! Both will work, but I've did the show zero values.