Excel 2003
When I try to enter firgures into a few cells in the spreadsheet, it keeps
showing the # sign when I go to the next cell. I can reselect the cell with the # signs in it and the numbers reappear but it automatically goes back to the # sign when I exit that cell. This is only happening in 3 or 4 cells on the sheet. What gives? |
Excel 2003
The # symbol usually appears if the cell is not wide enough to display all
the characters. Try widening your column to fix it -- Message posted via http://www.officekb.com |
Excel 2003
Try making the column wider.
-- Biff Microsoft Excel MVP "Susan" wrote in message ... When I try to enter firgures into a few cells in the spreadsheet, it keeps showing the # sign when I go to the next cell. I can reselect the cell with the # signs in it and the numbers reappear but it automatically goes back to the # sign when I exit that cell. This is only happening in 3 or 4 cells on the sheet. What gives? |
Excel 2003
.... or the font smaller? :-)
-- David Biddulph "T. Valko" wrote in message ... Try making the column wider. "Susan" wrote in message ... When I try to enter firgures into a few cells in the spreadsheet, it keeps showing the # sign when I go to the next cell. I can reselect the cell with the # signs in it and the numbers reappear but it automatically goes back to the # sign when I exit that cell. This is only happening in 3 or 4 cells on the sheet. What gives? |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com