bookendinSA
New Member
- Joined
- Sep 23, 2023
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Hi,
Please and thank you for your help. All my attempts to correctly display changes the values of the cell (view the true value when clicking on the cell). I must not have an "M" after the value - just the number. So custom formatting is not helping me - I probably don't know enough - hence my struggle. And the display results cannot be in an additional column/cell - it must be correctly displayed in the cell "E12" which also contains a formula: See below. The xl2bb is not working, even though I've enabled macros - does not copy the code so I can't paste it.
Formula
C12 | ='Sales data'!D4 | Value = 150,000
D12 | ='Sales data'!E4 | Value = 8.00
E12 | =(C12*D12) | Value = 1,200,000 | Formatting = number, no decimal spaces, show thousands delimiter
Problem: E12 should display as 1.2 BUT clicking on the cell should still display the real value of 1,200,00
Please and thank you for your help. All my attempts to correctly display changes the values of the cell (view the true value when clicking on the cell). I must not have an "M" after the value - just the number. So custom formatting is not helping me - I probably don't know enough - hence my struggle. And the display results cannot be in an additional column/cell - it must be correctly displayed in the cell "E12" which also contains a formula: See below. The xl2bb is not working, even though I've enabled macros - does not copy the code so I can't paste it.
Formula
C12 | ='Sales data'!D4 | Value = 150,000
D12 | ='Sales data'!E4 | Value = 8.00
E12 | =(C12*D12) | Value = 1,200,000 | Formatting = number, no decimal spaces, show thousands delimiter
Problem: E12 should display as 1.2 BUT clicking on the cell should still display the real value of 1,200,00