function alignment

A

aak420

Does anybody know hoe to align a function. My worksheet
is filled with currency cells. They seem to sort of
justify across the whole cell. Then I have one cell that
is a PV function cell. When it outputs total dollar
amount it is centered and not justifyied across whole
cell. ie. A1=50000 : (formatted as currency), A2=pv
(0.0375,1,-100000) : (formatted as currency).
 
F

Felipe

Copy one of the cells wich have to right format and go to
the PV cell. Select edit>paste special>formats
 

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

How do I concatenate two currency cells to show a price range? 5
Spaces in cells 1
Importing cells frmom a calendar workbook 4
Using Excel ActiveX Textbox to populate another worksheet cell 0
Help needed with IF function 1
Math Functions Not Working Properly 3
Copy a Table to another place with Column Alignment Displaced 1
no functions resolve when format of cells is text 7

Top