The Excel number is shown as an invisible character in the formula bar

[mostafagordan]

I saved some numbers from a database in an excel file.
Numbers in cells are displayed correctly. But in the formula bar, they are seen as undefined characters. When I click on the cell, the number in the formula bar is shown as an arrow, otherwise it is shown as an unknown character.
I did all kinds of things that were recommended in the groups to fix it. But it was useless.
I need urgent help.

------

Book1.xlsx
	A
3	100
Site Data

 

[LazyBug]

Hello and wecome to forum, @mostafagordan!
Would be helpful if you provide a screenshot of the entire Excel screen or (it's probably even better) you can place a copy (unclassified data only) of your workbook on a file sharing site like dropbox and give a link to it.

 

[mostafagordan]

file is here:

https://file.io/ADMJOd4ys78J

 

[LazyBug]

file is here:

https://file.io/ADMJOd4ys78J

 

[mostafagordan]

i'm sorry! check this:

Filebin | n1ctujn5g8iquz4u

Convenient file sharing. Think of it as Pastebin for files. Registration is not required. Large files are supported.

filebin.net

 

[LazyBug]

i'm sorry! check this:

Filebin | n1ctujn5g8iquz4u

Convenient file sharing. Think of it as Pastebin for files. Registration is not required. Large files are supported.

filebin.net

Unfortunately, my antivirus won't let me open this page.

 

[mostafagordan]

Book1.xlsx is available for download

Click to access the Book1.xlsx (59.6 KB) download with TransferNow

www.transfernow.net

or

FEX.NET

fex.net

or

File Link Information - BiteBlob

biteblob.com

 

[Alex Blakenburg]

Do you know how to use VBA ?
Using a copy of your workbook try
• Alt+F11
• If you can't see the immediate window Ctrl+G
• Then copy the below into the immediate window and hit enter

ActiveSheet.UsedRange.Replace ChrW(65279), ""

Then let us know what happens ?

 

[mostafagordan]

Yes, I know how to work with VBA.
Problem solved with your solution, thank you very much.

While I was waiting for the answer, I separated the number characters through the VBA code and was surprised when I saw a "?" character that it was in front of each number.

Please explain where the problem comes from?

 

[Alex Blakenburg]

The most likely is that it was somehow introduced as part of the transfer process from the database to excel.
You can get unusual characters in a database through an import or copying pasting data in but that would seem less likely for a numeric field.