Use formating to display cents as dollars and cents ?

M

Mark Parent

I know that I can use a comma in a format to "scale" a
cell's value by 1000 before display, but what I'd like to
do is use formatting to "scale" a cell's value by 100
before displaying. Is this possible ?

My values are all cents (12345) and I'd like to use format
to display them as dollars and cents ($123.45). I know
that I can simply use another column, use a formula to
divide the original value by 100, and then format to
display what I need, but I'm hoping I can use formatting
to avoid creating another column and formula. (I'm trying
to keep this simple so I can document the steps for my
customers to do something on their own.)

Thanks to anyone taking the time to consider this !
 

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

using randombetween to arrive at dollars and cents 3
Separating dollars and cents 5
Extracting dollars and cents 1
How to get decimal point between dollars and cents 1
How do I convert dollars and cents to text, and prefill the cell . 1
Discrepancy in calculations with dollars and cents 10
dollars/cents multiplied by hours/minutes or tenths 1
Changing $ format to a written format 2

Top