Hello,
I am trying to have a script which checks the content of a cell (say A1); If the content of the cell is a number (it could be negative, positive, integer, decimal), than convert the cell value into a text.
Could you please advise?
Thanks
Hello,
I am trying to have a script which checks the content of a cell (say A1); If the content of the cell is a number (it could be negative, positive, integer, decimal), than convert the cell value into a text.
Could you please advise?
Thanks
The ISNUMBER() function will tell if a cell is a number. ISTEXT() can tell if a cell is text (including numbers stored as text). The TEXT() function can convert a number to a text string in a specified number format.
IS... functions: https://support.microsoft.com/en-us/...1-f2d869135665
TEXT function: https://support.microsoft.com/en-us/...8-93d29371225c
Number format codes: https://support.microsoft.com/en-us/...7-9c9354dd99f5
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks