Re: Linking cells with changing format

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Too many variables :-(

"Gord Dibben" wrote:

Use same CF on both cells.


Gord Dibben MS Excel MVP

On Tue, 6 Oct 2009 05:43:01 -0700, Wombat <Wombat@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Just saw the previous post... What are the odds of two people asking the same
thing at the same time!

Doesnt look hopeful unfortunately but I'll keep an eye on the other thread
to see the answers.

"Wombat" wrote:

Hello people

I was wondering if its possible to copy a cell (from one tab of a document
to another) and have them linked so that the format will change in the new
cell if the format of the original is changed...

Thanks for any suggestions :-)


.



Relevant Pages

  • RE: Linking cells with changing format
    ... Doesnt look hopeful unfortunately but I'll keep an eye on the other thread ... I was wondering if its possible to copy a cell (from one tab of a document ... cell if the format of the original is changed... ...
    (microsoft.public.excel.misc)
  • Re: Linking cells with changing format
    ... Doesnt look hopeful unfortunately but I'll keep an eye on the other thread ... I was wondering if its possible to copy a cell (from one tab of a document ... cell if the format of the original is changed... ...
    (microsoft.public.excel.misc)
  • Easily resolved
    ... 'Text' formatted cells displaying numbers in scientific format ... I use Excel to view statement information downloaded from my bank in CSV ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ...
    (microsoft.public.excel)
  • Re: Actual solution
    ... Then format the cells as text ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ... Microsoft Excel MVP ...
    (microsoft.public.excel)
  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)