Formatting 1st cell with a $
Qty Price Total
1 $5.00 $5.00
2 5.00 10.00
3 5.00 15.00
I only want the first Price and Total amount with a $ sign. I want this to
happen regardless of which cell I enter the first price and total into.
Sometimes this will be on line 1 - sometimes 2 - etc. I wanted to automate
this feature so I can lock the form. So regardless of which line has the
first amount - be it line 1 or line 15 the amounts will have the $. All
numbers after that will be without the $
"Uma Nandan" wrote:
can you please poste an example of your data & out what ur expecting
"TaylorLeigh" wrote:
I have an invoice template and with a price and extended price column. Due
to the nature of the information the first price and extended price are not
always on the same line on the invoice. How can I get the first and only the
first figures to have the $ sign.
Thanks,
|