CODEWITHSUNDEEP
excel
user339108
user339108

Reputation: 13101

How do I prevent values being shown as # in excel

I have a cell which is formatted as Text field with wrap text on. The values are shown as "#" when I move away from the cell, how do I prevent it?

Upvotes: 1

Views: 77

Answers (1)

Leniel Maccaferri
Leniel Maccaferri

Reputation: 102438

Try to expand the column size (width). If this doesn't help try to format the cell as General instead of Text.

When this happens to me I just have to expand the column size so that the content fits perfectly within the cell.

More about it here:

Excel - #### sign in cell formatted "Wrap Text"

Upvotes: 5

Related Questions