Help!

automatically divided by 1000

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map RSS
Next:  how to prevent format convertion  
Author Message
Jian
External


Since: Apr 29, 2004
Posts: 1
PostPosted: Fri Dec 26, 2003 12:51 pm    Post subject: automatically divided by 1000
Archived from groups: microsoft>public>excel>datamap (more info?)
everytime i input a figure into a cell in EXCEL, it
automatically divided by 1000. i have reinstalled twice,
but it till happands. could you give help. thanks
Back to top
Nick Hodge
External


Since: Jul 21, 2004
Posts: 1917
PostPosted: Sat Dec 27, 2003 8:57 am    Post subject: Re: automatically divided by 1000 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Jian

Tools>Options...>Edit. Uncheck 'fixed decimal places'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT RemoveThis @zen.co.uk.ANDTHIS


"Jian" <anonymous RemoveThis @discussions.microsoft.com> wrote in message
news:011701c3cbe9$ab439f60$a401280a@phx.gbl...
 > everytime i input a figure into a cell in EXCEL, it
 > automatically divided by 1000. i have reinstalled twice,
 > but it till happands. could you give help. thanks<!-- ~MESSAGE_AFTER~ -->
Back to top
donhorn



Joined: Dec 18, 2006
Posts: 1
PostPosted: Tue Dec 19, 2006 1:27 pm    Post subject: Re: automatically divided by 1000 [Login to view extended thread Info.]
Jian wrote:
everytime i input a figure into a cell in EXCEL, it
automatically divided by 1000. i have reinstalled twice,
but it till happands. could you give help. thanks


I'm having the same problem. Whats the solution.

donhorn
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum