One of our agents fixed a problem with the formatting but the user insists that Excel on a different co-workers computer will automatically format a number when he types a number in a not formatted cell.

To format a number we need select a format for the cell or column or row first, then excel will do the format when we type in a number. We don't know how it can automatically do the format if the cell format is general.<o:p></o:p>

Thanks.

• Moved by Bill_Stewart 18 hours 27 minutes ago Move to more appropriate forum

Best to ask the experts in an Excel forum: http://answers.microsoft.com/en-us/office/forum/office_2010-excel/