[VBA]Inserted value does not get formatted

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
 
T

Tom Ogilvy

In VBA, you need to use US formatted number

Range.Value = 0.99999

(no quotes, use period rather than comma).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Value into cell automatically when new rows are created/inserted 1
Mid column sum formulas with varied ranges to sum 17
Create list depending on inserted value in a cell 1
Mimic Value Being Typed Into Cell 10
VBA: Copy a date and paste as text 4
InputBox default value? 4
Insert Row based on count and copy range to inserted rows 2
concatenate text and formatted cell 2

Top