View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default formating numbers

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

"hadron" wrote:

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