Powershell - Unable to add specific text in Excel Comobject

Question

I'm attempting to add specific text to a cell in an Excel sheet using Powershell. For example:

$1,500/$2,500

The closest I can get to adding that text into a cell with the proper formatting is to remove the characters: 1500/2500. I've tried treating the cell as text and entering it as a formula.

Does not work:

$wb.Sheets(1).Range("G9").Formula = "=""$1,500""&""/""&""$2,500"""

Or

$wb.Sheets(1).Range("G9").NumberFormat = "@"
$wb.Sheets(1).Range("G9").Value = "$1,500/$2,000"

BigBen · Accepted Answer · 2020-08-18 19:16:52Z

1

Use single quotes instead of double:

$wb.Sheets(1).Range("G9").Value = '$1,500/$2,000'

You can eliminate the $wb.Sheets(1).Range("G9").NumberFormat = "@" as well. It is not necessary to change the cell formatting to text.

answered Aug 18, 2020 at 19:16

BigBen

50.4k7 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell - Unable to add specific text in Excel Comobject

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related