I see just a single # in a cell as a result of a vlookup.

New Contributor

I have a vlookup formula which is returning the correct data however it is displaying it as a # only in the cell.

When I hover over the # it is revealing the correct information but not displaying it as a value as a default. 

Any suggestions as to how to correct this?

Any help very much appreciated.

1 Reply
Never mind, I sorted it out. Had text direction set to verticle offset. What a numpty I am.