View Single Post
  #9   Report Post  
Lepista Lepista is offline
Junior Member
 
Posts: 3
Default

This is great. Is there any way to keep the formatting of the referenced cells?

eg:
A1; 2.11237864872634 (formatted to 2 DP, for example)
A2: 3.141592654 (formatted to 2 DP, for example)
A3: = A1 + A2
ConvertFormula(A3) shows "2.11237864872634 + 3.15297459"

Instead I would like "2.11 + 3.14"

Any help would be greatly appreciated!