Thread: Not rounding numbers in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Not rounding numbers in VBA
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?




Reply With QuoteReply With Quote