| 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 Topic | Post Reply Login |
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 | ||
| Replies - Displaying 1 to 1 of 1 | Order Replies By: Most recent | Chronological | Highest Rated |
 | Rate this: (3.5/5 from 2 votes) 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 |
| Displaying page 1 of 1 |
Excel templates and solutions matched for Convert numbers to a specific text string:Solutions: Serial Number to Barcode |