I
Ivan
Hello,
Here is my quandry: I have a data table that imports
information from another part of my worksheet. I want to
import also some footnotes (superscripted) into the same
cell (this suggests concatenation to me). The problem is
that my original data contains anywhere from 0 to 3 decimal
places and in the table it _MUST_ be represented as 3.
Normally a simple formatting of the cells would work, _BUT_
when I add the concatenation command, it ignores the
formatting rule and instead prints the whole thing.
examples:
this is what I want:
10.000footnote (original data is 10)
12.300footnote (original data is 12.3)
13.660footnote (original data is 13.66)
18.777footnote (original data is 18.777)
this is what I get:
10footnote
12.3footnote
13.66footnote
18.777footnote
so it only works when 3 decimals are given...
help please.
thanks,
Ivan
Here is my quandry: I have a data table that imports
information from another part of my worksheet. I want to
import also some footnotes (superscripted) into the same
cell (this suggests concatenation to me). The problem is
that my original data contains anywhere from 0 to 3 decimal
places and in the table it _MUST_ be represented as 3.
Normally a simple formatting of the cells would work, _BUT_
when I add the concatenation command, it ignores the
formatting rule and instead prints the whole thing.
examples:
this is what I want:
10.000footnote (original data is 10)
12.300footnote (original data is 12.3)
13.660footnote (original data is 13.66)
18.777footnote (original data is 18.777)
this is what I get:
10footnote
12.3footnote
13.66footnote
18.777footnote
so it only works when 3 decimals are given...
help please.
thanks,
Ivan