[VBA]Inserted value does not get formatted

  • Thread starter Thread starter Klimaks
  • Start date Start date
K

Klimaks

I insert a value with a Range.Value = "0,99999".

The cell where I insert as the following format "hh:ss". But the value
are inserted like "0,9999". When I edit the value and press enter the
suddenly get the correct format?

What should I do
 
In VBA, you need to use US formatted number

Range.Value = 0.99999

(no quotes, use period rather than comma).
 
Back
Top