ExcelBanter - Excel spread sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel spread sheet (https://www.excelbanter.com/excel-discussion-misc-queries/255041-excel-spread-sheet.html)

hondo

Excel spread sheet

Why random data is replaced with a number symbol. Date entered as 2/2/2010
but ######## shows up in the cell.

Ron@Buy

Excel spread sheet

iCould be a number of reasons:
First try either widening the column or reducing the font size.
Come back if that doesn't work

"hondo" wrote:

Why random data is replaced with a number symbol. Date entered as 2/2/2010
but ######## shows up in the cell.

All times are GMT +1. The time now is 05:49 PM.