Excel - Retain Original Formatting Help 2

[mukker]

I hope one of you excel wizards can help me with this? I'll do my best to explain it?

I have one spreadsheet where the formatting of every cell is set like this: 547,988
And another spreadsheet where it is set like this: 0.548.

The two figures are actually identical, the second spreadsheet just rounds it up.

What i'm trying to achieve is: Copy 547,988 to 0.548 and retain the 0.548 format of the cell? As clear as mud? I have tried paste special and copied the formatting code from the second worksheet, but no joy.

Format of 0.548 = #,##0.000;[Red](#,##0.000)
Format of 547.988 = #,### ;[Red](#,###)

I'm unable to link 0.548 to 547,988 because 547,988 is linked to multiple .xls files and external (OFA) sources. When i've tried linking 0.548 to 547,988 i get a 'circular reference' error??

I've confused mesel now. LOL

 

[SkipVought]

Hi,

Maybe you have confused mesel, but you certainly have confused me also.

"...Copy 547,988 to 0.548 ..."

"I'm unable to link 0.548 to 547,988 ..."

Copy or Link?

"No joy" but you never really explain exactly what is causing your pain.

Please state your problem with cogent examples, clearly concisely and completely.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mukker]

Try again...

Spreadsheet1
Cell A1 = 547,988
Spreadsheet2
Cell A1 = 0.547988 (but actually gets rounded up to 0.548)

Same figures just in different format.

Now, if i copy spreadsheet1, cell A1 (547,988) to spreadsheet2, cell A1 it shows as 547,988 and not as 0.547988.

I just want speadsheet two to stay formatted as is: (0.547988)

I've lost the will to live now. LOL.

 

[SkipVought]

"Same figures just in different format."

Same sequence of numeric characters, different numeric values.

FORMAT does not change numeric VALUES.

Math does.

547,988 = 0.547988 * 10^6



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[GlennUK]

Mukker,

is it that the target cell has formatting that reduces numbers by a factor of a million? Is that what you mean?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[mukker]

Mukker,

is it that the target cell has formatting that reduces numbers by a factor of a million? Is that what you mean?
Cheers, Glenn.

Yes that's exactly right. Why didn't i say that. LOL

 

[mukker]

Thank you, thank you and thank you.

It was the math. A simple sum formula solved the problem.