ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Issue with Number Conversion to text (https://www.excelbanter.com/excel-worksheet-functions/245564-issue-number-conversion-text.html)

Yuvaraj Mani

Issue with Number Conversion to text
 
Hi,

I have a Macro which imports the data from the excel and generated the New
excel report.

On generation of the Report 'Type Mismatch' error Occured for certain
Users(Poland users) but it worked fine for the United states Users.

I noticed the issue to be with Blank vaue on the Digit group code of
Regional setttings on the Users Machine.So I replace the Blank value with the
Dot(.) value and it worked fine.

But I wanted to know whether there will be any impact to the the Users for
replacing the Digit blank Space with the (.) value on the Digit group code
of the Regional settings for the Poland users.




All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com