Excel on Mac

Copper Contributor

My excel automatically adds a $ in a column of numbers.  If there are 5 numbers, it does not add.  If there are 2 numbers, it ads the $.  How do I make it so that the $ is not added to any of the numbers?

1 Reply

@eastsidecollegeconsult How is the column formatted, or the individual cells in it? What you describe could be achieved by conditional formatting, but that's not something one would do accidentally.

If possible, upload a copy of the workbook that has the issue. Delete any confidential information in it.