Number stored as text

  • Thread starter Thread starter Prashwee
  • Start date Start date
P

Prashwee

Hello All

I have changed my reginal settings to swedish

Then i use the folowing statement in my application
ApExcel.Cells(1, 1).value =FormatCurrency("1,00", 2, vbFalse, vbFalse,
vbTrue)


when i open my Excel sheet, cell 1,1 has a smll green trangle . when i
press it it warns "Number stores as text".
how do i avoid this. I need to store it as number


/Thanks in advance
Prash
 
Try inserting the following before your line of code:

Cells(1, 1).Value = Cells(1, 1).Value * 1
 
Hi again
I got my all my currancy formats gone.
I can store this as a numbe without changing the formats i got from regional
settings
Thanks in advance
Prash
 
Hi, you can do it this way:

range("a1").select ' or cells(1,1).select
selection.numberformat = "0.00" ' this is for 2 digits

Any help under numberformat in Excel.

Henrich

„Prashwee" napísal (napísala):
 
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

Number stored as text 4
Number Stored As Text 2
How to prevent a number stored as text from converting to a number 2
number stored as text 1
Numbers stored as text 2
custom function to convert numbers stored as text 4
Formatting problem 6
Number displayed as text difficulties 4

Back
Top