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 Friday, June 26, 2015 1:01 PM Move to more appropriate forum

Hi,

From your description, I recommend we create a custom cell style and then apply it to the worksheet.

Reference:

https://support.office.com/en-us/article/Apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22?CorrelationId=b559bf38-4702-4d05-bd52-16a4e609c071&ui=en-US&rs=en-US&ad=US#BMbasestyle

Regards,

George Zhao
TechNet Community Support