Formatting Cells

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I am creating a quote template and would like to create
cells with the same type of formatting as the Excel
invoice templates ie. the cells appear "blank" until a
number is entered. Once a number is entered the cell is
then formatted eg. $10.00 and is included in the sub
total, taxable rate, etc. Thanks.
 
I've just fixed it. From the existing Excel invoice, I
copied the formatting characters within the custom format
dialog box of the cell and pasted it into my new quote as
a new custom format item. Viola!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"What-if" formula for either a manual entry and automated entry 3
Tax Invoice 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Suppress @VALUE! on a template. 4
Conditional formatting in Excel 2010 2
excel macro 1
Formulas with no results 3
Workbook Fotmula 2

Back
Top