Previous Topic Next Topic

MS Excel Number format error

Solved/Closed
zac - Aug 10, 2009 at 01:00 AM
 Akoh - Jan 15, 2014 at 10:59 AM
Hello,

I use Ms Execl in that I have a error it like this.....

1. when I type a number 400 in the cell an give Enter. It is not showing the exact value as 400 but it shows as 0.400..

pleace sumboby clear ma error .... how to rectify it... plz
Related:

2 responses

Answer 1 / 2
adi
Sep 3, 2010 at 08:25 AM
Open Excel > Office button>Excel options - select Advanced and un - check the "Automatically insert a decimal point" and "OK". Now your problem may not arise.
1
RP
May 26, 2011 at 10:44 AM
Just got the same issue, Thanks for your solution!
0
nagu
Sep 27, 2013 at 06:38 AM
thanks for solving
0
Akoh
Jan 15, 2014 at 10:59 AM
Thanks for your support
0
Answer 2 / 2
Guy
Aug 10, 2009 at 01:21 AM
Try this,
1.Click cell that you have problem
2.right click and select "Clear constents"

May be help you
-1

Similar discussions

Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

2 responses
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses