Forum Discussion

VShostak's avatar
VShostak
Copper Contributor
Nov 06, 2023

macro VBA excel change cell format

Hello!   In my macro, I used code to replace "." on ",". However, during this replacement, the cell format changes to text. How can I write code to ensure that the format remains as a number?   S...
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Nov 06, 2023

VShostak 

The line Selection.NumberFormat = "@" sets the number format to Text.

Remove that line.

VShostak's avatar
VShostak
Copper Contributor
Nov 06, 2023
Now they change "." on space " " instead ",".
Сan you tell me how to write the code correctly.
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 06, 2023

    VShostak 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources