Home > Forum Home > Automating Data Analysis Tasks > Convert numbers to a specific text string Share

Convert numbers to a specific text string

Excel Help for Convert Numbers To A Specific Text String in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Convert Numbers To A Specific Text String

Rate this:
(3/5 from 1 vote)
ConfusedHello,

I have a number that I need to convert to the following text string formats. I have successfully converted 45 to the following text string using the custom format:
Wait(45000);

But it does not work with the ones below:

Convert 0.05 to the following text string:
<ParameterString>0.05</ParameterString>

Convert 0 to the following text string:
<Time>0</Time>

These are codes for a instrument and the text must be in the exact format above. Can anyone help.

Regards,

Frank
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Sad
Rate this:
(3.5/5 from 2 votes)
You can specify values as test by preceding them with a single apostrophe '.

It seems as through you want to wrap text into tags.  To do this, you can concatenate text using the & sign e.g. ="<Time>" & A1 & "</Time>".
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Convert numbers to a specific text string:

Solutions: Serial Number to Barcode