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
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