Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number conversion to text in Ms excel bafarooqi Excel Worksheet Functions 2 November 20th 08 08:40 AM
Text to Number conversion ALLYANA New Users to Excel 6 October 16th 06 03:33 PM
File conversion-text encoding issue elhirsch Excel Discussion (Misc queries) 2 September 11th 06 03:19 PM
Vlookup text conversion issue PamKT Excel Discussion (Misc queries) 2 August 28th 06 05:59 PM
Conversion of a Number into English Text Nasir Ali Excel Worksheet Functions 1 July 28th 05 08:50 AM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"