formating numbers

  • Thread starter Thread starter hadron
  • Start date Start date
H

hadron

cell is formated 0,0000 but when I write 2,111 result is 2111,0000 - why?
 
Hi,

When I use that number format, the result I see is 02,111 - anyways I guess
this is because of the Windows Number setting. What result do you see if
you replace the 0's with #

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Hi,

On the assumption that , is your decimal seperator then its doing precisely
what your telling it to do and displaying 4 decimal places. What would you
like it to do?

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top