aligning decimal points

L

lauren22dyad

does anyone know how to align decimals? I have inserted functions into
several cells, and when i copy it into the word doc, and open back up
as a template, the decimals dont line up. Is there a way to format the
cells so the decimals line up?
 
J

JE McGimpsey

lauren22dyad said:
does anyone know how to align decimals? I have inserted functions into
several cells, and when i copy it into the word doc, and open back up
as a template, the decimals dont line up. Is there a way to format the
cells so the decimals line up?

Within XL, you can align decimals using

Format/Cell/Number/Custom 0.???

which will allow up to 3 decimal places.
 

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

Top