Sign in with
Sign up | Sign in
Your question

Excel standard format for cell

Last response: in Applications
Share
November 26, 2012 10:11:09 AM

My excel change the standard format of numbers to 22000.0.00
and apply that format to: number, account and currency. How can I correct it?
December 5, 2012 2:52:08 AM

Highlight the numbers you need to correct.
Press CTRL+1
Click on the Number tab
Change to the desired format.

OR

Highlight the numbers you want to change.
Right click and select Format Cells
Click on the Number tab
Change to the desired format
m
0
l
!