Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
& function cell format translation.
I have a cell D2, that has A1&B1 in it. Problem is, I want the format
from cell A1 to translate over also. IE decimal placing to 1dp and in another case superscript to translate over also. I have tried custom number format of #,0 and #.0 to no avail. Cell D2 displays 7000g A1=7000.0 B1=g Thanks in advance for your advice, Slash. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
& function cell format translation.
You can't using custom text format since when you concatenate A1 and B1 it
becomes text, you can use this which is not formatting but text =TEXT(A1,"0.0")&" "&B1 having said that is there a reason you cannot use a custom format like 0.0" g" or do you have multiple values that need to be concatenated -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon wrote in message ups.com... I have a cell D2, that has A1&B1 in it. Problem is, I want the format from cell A1 to translate over also. IE decimal placing to 1dp and in another case superscript to translate over also. I have tried custom number format of #,0 and #.0 to no avail. Cell D2 displays 7000g A1=7000.0 B1=g Thanks in advance for your advice, Slash. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
& function cell format translation.
Thanks for that, it has solved my problem. How do I get the superscript
to translate through to the cell also? EG A1=10oC A2=+/- 1oC A3=A1&A2 A3 Displays 100C+/-10C but I want to keep the superscript for the "o" Thanks, Slash. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
& function cell format translation.
Excel doesn't support that kind of formatting with formulas. If you convert it
to a value, then you can do the formatting, though. wrote: Thanks for that, it has solved my problem. How do I get the superscript to translate through to the cell also? EG A1=10oC A2=+/- 1oC A3=A1&A2 A3 Displays 100C+/-10C but I want to keep the superscript for the "o" Thanks, Slash. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Function that Returns address of that cell? | Excel Worksheet Functions | |||
Reading Cell Function??? | Excel Worksheet Functions | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |