Adding text string to a number across worksheets

  • Thread starter Thread starter Trey
  • Start date Start date
T

Trey

I have in sheet 2 (the calculation sheet) a ratio
calculated by dividing one cell by another. I used the
ROUND function to remove all but 2 digits (I would like
the figure to read "3.51 million") and have added &"
million" to the formula in the cell. This works fine on
sheet 2 (it displays "3.51 million" in the cell).
However, when I try to reference this cell in sheet 1 (the
sheet that will be used to present all the information)
simply by setting the cell in sheet 1 equal to the cell in
sheet 2, it adds "million" on again, resulting in "3.51
million million" displaying on sheet 1. Does anyone have
any idea what's going on and what I could do to fix this?
Thanks for any help you're able to offer.
 
Perhaps it is formatted to show the word "million" after the cell content.
If you type any old number or text in the cell, does it show million after
that also?
 
For the cells where you want it to read 3.51 million, format those cell
as Custom - and format is as ##.## "Millions"

Hope this works.

Visha
 
There seems to be a habit of people replying to the last (most recent)
poster in ExcelForum, rather than to the original question. To correct that,
press the "reply" button near the original post, and not a follow-up post
unless you are addressing the follow-up post.
 
Back
Top