Convert numbers to a specific text string

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

Convert Numbers To A Specific Text String

Rate this: (3/5 from 1 vote)

	Hello, 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 francis on 01 Oct 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Using the apostrophe to specify text 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 Excel Helper on 01 Oct 2011

Displaying page 1 of 1