View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
serdar serdar is offline
external usenet poster
 
Posts: 11
Default Not rounding numbers in VBA

thats ok. my solution was funny:

....=3+0.514


"Ron de Bruin" , haber iletisinde şunları
...
You can use this

With Cells(1, 1)
.NumberFormat = "General"
.Value = "3.514"
End With


--
Regards Ron de Bruin
http://www.rondebruin.nl


"serdar" wrote in message
...

Cells(1, 1) = "3.514"

This gives 4 in A1. Is it possible to pass the actual value without
preformatting the cell?