Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
source data editor in Excel 2007 dont seem to allow copy and past. | Charts and Charting in Excel | |||
Excel and Notepad: how avoid additional inverted commas after copy | Excel Discussion (Misc queries) | |||
cannot copy/past in Excel | Excel Discussion (Misc queries) | |||
Missing commas | Excel Worksheet Functions | |||
How: Need 2 Copy sentences with commas & paste into one cell. | Excel Programming |