GreenTree
11-07-2009, 10:30 PM
Depending on the number format, a cell with the value 4.25 could look like $4.25 or 4 or 4.2500 or 425% or 4 Jan 6:00 AM or etc etc etc.
Let's say that I want to display the same thing that A1 has in it, in B1, but I don't know ahead of time what the number format of A1 is going to be. (There's actually a Lookup involved, and depending on which column is being pointed to, the data may be in any of several formats, but the lookup part isn't the question here.) What should go in B1 so that what the user sees there looks the same (425% -- 425%, or 4.2500 -- 4.2500, or etc) as A1?
(Tried conditional formatting, but that's colors & fonts & backgrounds, not number format. At least not in 2003, which is what I'm using.)
Many thanks,
G.T.
Let's say that I want to display the same thing that A1 has in it, in B1, but I don't know ahead of time what the number format of A1 is going to be. (There's actually a Lookup involved, and depending on which column is being pointed to, the data may be in any of several formats, but the lookup part isn't the question here.) What should go in B1 so that what the user sees there looks the same (425% -- 425%, or 4.2500 -- 4.2500, or etc) as A1?
(Tried conditional formatting, but that's colors & fonts & backgrounds, not number format. At least not in 2003, which is what I'm using.)
Many thanks,
G.T.