Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel2000: number format problem 1

Status
Not open for further replies.

jdol

Programmer
Jan 2, 2002
7
0
0
NL
I,m using Excel2000 on 2 PC's, one with Win98SE (NL), and one with Win98SE (UK).
On both machines all Win regional settings and Excel format- options are the same. But on the machine with Win98SE (UK) an integer (p.e. 5) will allways be displayed as 0,05 in stead of 5.
Who knows what's the problem and how can I make an integer being displayed in the correct integerformat?

Jan D.
 
Tools, Options, Edit tab, uncheck Fixed Decimal Places.
 
Yes, xlhelp, that's the solution!

Thanks

Jan D.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top