Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
Why does the Format command in Excel VBA perform differently on two different computers?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 91%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mikael Björling
0
Reputation points
I have an Excel VBA code in an older macro that performs differently on two different computers, but I do not why that is. An input string A is "27.67" and the code says B=Format(A). In one computer the result is a number B that can be used in calculations with the value as given by the string. On the second computer, the numeric value becomes "2767" so the decimal point is not correctly treated. Can anyone explain what I must do to make the code work on both computers?
Excel
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,720 questions