An interesting problem related to office-excel

%3CLINGO-SUB%20id%3D%22lingo-sub-917413%22%20slang%3D%22en-US%22%3EAn%20interesting%20problem%20related%20to%20office-excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-917413%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20friends%2C%20I%20met%20a%20problem%20when%20using%20excel%20that%20really%20expect%20your%20help%3A%3C%2FP%3E%3CP%3EWhen%20I%20create%20a%20new%20excel%20workbook%2C%20and%20input%20numbers%20eg.%20123%2C%20it%20will%20show%20123.%3C%2FP%3E%3CP%3E%26nbsp%3BBut%20when%20I%20input%2012.3%2C%20it%20will%20show%2012.%20Mar.%3C%2FP%3E%3CP%3EOk...I%20change%20the%20format%20to%20numbers%2C%20and%20input%2012.3%2C%20it%20show%2043536.00.%3C%2FP%3E%3CP%3EWierd.%20I%20change%20the%20format%20to%20text%2C%20and%20input%2012.3%2C%20okay%20it%20show%2012.3.%20However%2C%20it%20cannot%20be%20used%20for%20calculation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20can%20help%20me%20on%20this%20interesting%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-917413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi friends, I met a problem when using excel that really expect your help:

When I create a new excel workbook, and input numbers eg. 123, it will show 123.

 But when I input 12.3, it will show 12. Mar.

Ok...I change the format to numbers, and input 12.3, it show 43536.00.

Wierd. I change the format to text, and input 12.3, okay it show 12.3. However, it cannot be used for calculation.

 

Anyone can help me on this interesting problem?

5 Replies
Highlighted
Select all cells (top left corner arrow)
Right click on shaded cells
Select "Format Cells..."
On "Number" tab, highlight 'General'
Click "OK"
Highlighted

hi@AccotinkCaptain thank you sooooo much for giving me the reply!! lol

I tried but...nowhere to select general on number tab. Did I made something wrong or my excel is not good? Here is the pic

clipboard_image_0.png

Highlighted

I see 'General' on the left bar (Unless that's not what you're talking about)!

On the left side bar Under "Category:" Select 'General'

 

fghj.JPG

Highlighted
Highlighted

@Lilith0323 Yup! Then click "OK" 

now try typing the numbers in the cell, see if that worked