commas missing at copy and past in excel
Norman,
Thank you very much, that worked perfectly.
Best regards
Michael
"Norman Jones" wrote:
Hi Michael,
"=PROPER(RC[-11]& "", "" & RC[-10]& "" ""& RC[-9]&" & _
" "" ""& RC[-8]& "".?"" &" _
& " text(RC[-5],""0"")&""^"")"
Should read:
"=PROPER(RC[-11]& "", "" & RC[-10]& "" ""& RC[-9]&" & _
" "" ""& RC[-8]& "".?"" &" _
& " text(RC[-5],""#,##0"")&""^"")"
---
Regards,
Norman
|