Re: [ExcelVBA] Excel VBA date and number error

 

Hi All

The short answer is that you should look at Regional Settings/International in your PC, and in the PC where the spreadsheet came from.

The long answer is very long.

Del +++

>________________________________
> From: tradutorpublico <laertetrad@gmail.com>
>To: ExcelVBA@yahoogroups.com
>Sent: Tuesday, 14 February 2012, 20:07
>Subject: [ExcelVBA] Excel VBA date and number error
>
>
> 
>Hi
>
>I'm writing a date and number in a cell, but I'm getting format errors. The date format is in Portuguese, but the VBA is writing the date in the English format.
>
>It writes the number, but for some reason, it is written in the wrong format and the spreadsheet does not use it in calculations. If I retype the number, then it works fine.
>
>Oddly enough, it used to be all right a couple of days ago.
>
>I have tried applying the right formats both in the data source and target spreadsheets, but it did not work out.
>
>The date and number format are OK in the source spreadsheet.
>
>All be the best,
>
>Laerte J Silva
>
>
>
>
>

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___