[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).
 
You must log in or register to reply here.

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

Conditional Formatting with VBA 4
Displaying cell contents 1
VBA: Insert rows 1
VBA to insert .xlborder if cell value not equal to previous cell 2
Mid column sum formulas with varied ranges to sum 17
inserting graphics in a conditional formatting 1
VBA - retrieve data on last create named range from previous inserted named range 0
DoCmd.RunSQL - Need help! 1

Back
Top