Reply to thread

Message: [QUOTE="Ron Rosenfeld, post: 3848257"] It is hard to give specifics without knowing more. You can't just copy the format using worksheet functions. However, you could use the CELL worksheet function to determine whether the original cell is formatted as Percentage; then use the TEXT worksheet function to display this as desired. For example, assuming that your cells will be displayed as either a Percentage with 2 decimal places; or a number with 2 decimal places: =TEXT(A1,IF(CELL("format",A1)="P2","0.00%","0.00")) Look at HELP for the CELL worksheet function for other options. Be aware that merely changing the format of a cell does not trigger a calculation event, so the CELL worksheet function may not update until some value changes. --ron [/QUOTE]