formating numbers

  • Thread starter Thread starter hadron
  • Start date Start date
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
 
Back
Top