ExcelBanter - Text & Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text & Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/210499-text-numbers.html)

Mike

Text & Numbers

One of my cells reads *97. I would like another cell to recognize this as the
number 97. Any suggestions ?

Mike

Text & Numbers

Sorry ... this was already answered a few days ago. Thanks for the help !

"Mike" wrote:

One of my cells reads *97. I would like another cell to recognize this as the
number 97. Any suggestions ?

All times are GMT +1. The time now is 08:18 PM.