ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I convert an imported number to text (https://www.excelbanter.com/excel-worksheet-functions/255746-how-do-i-convert-imported-number-text.html)

Lyn

how do I convert an imported number to text
 
I am downloading data from a computer and wish to convert the number to text
in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine
and each one represents a different problem or failure of a piece of machinery

Jacob Skaria

how do I convert an imported number to text
 
Have you tried Find and Replace (Ctrl+H)
--
Jacob


"Lyn" wrote:

I am downloading data from a computer and wish to convert the number to text
in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine
and each one represents a different problem or failure of a piece of machinery



All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com