How to copy custom number formats

[Simon Lenn]

Hello All

I have a custom number format for a Excel Cell A1 which is #,##0.00
"CAD"

and in A1 I now have a value 1000 CAD.

I have assigned cell B1 as =A1 but an external application when the
report is run populated now cell A1 as 20000 MXP and now my cell B1
says 20000 CAD and not 20000 MXP and when I check the format for B1 it
still as the format as
#,##0.00 "CAD" whereas now the format of my cell A1 is #,##0.00
"MXP" appears only the value and not the format is being copied.

Can any of you suggest a workaround to resolve this problem.

Many thanks
Simon Lenn

 

[Paul]

Hello All

I have a custom number format for a Excel Cell A1 which is #,##0.00
"CAD"

and in A1 I now have a value 1000 CAD.

I have assigned cell B1 as =A1 but an external application when the
report is run populated now cell A1 as 20000 MXP and now my cell B1
says 20000 CAD and not 20000 MXP and when I check the format for B1 it
still as the format as
#,##0.00 "CAD" whereas now the format of my cell A1 is #,##0.00
"MXP" appears only the value and not the format is being copied.

Can any of you suggest a workaround to resolve this problem.

Many thanks
Simon Lenn

A formula, such as =A1, can only ever transfer a cell value from A1. It can
never transfer a format.