Try to enter asRich (BB code):'(1234)
Or format the cells as text before data entry.
'(1234)
right click
paste special /text
over a text formatted cell
Have you tried custom number formatting such as #,##0_);(#,##0)
Just keep in mind, formatting a cell only affects the displayed text in the cell, the underlying value in the cell will remain unchanged... for your case, that means the cells will still contain negative numbers. I am not sure if that will matter to you or not in you ultimate usage of that data, so I figured I would mention it to you "just in case".thanks that also works
Just keep in mind, formatting a cell only affects the displayed text in the cell, the underlying value in the cell will remain unchanged... for your case, that means the cells will still contain negative numbers. I am not sure if that will matter to you or not in you ultimate usage of that data, so I figured I would mention it to you "just in case".