Remove Text Formatting in the Surfer Worksheet

It is important the data you use to create maps in Surfer are formatted as numbers. If your data is formatted as text, you can see a single quote mark (') before the number in the Surfer worksheet. The data will also be left aligned if it is formatted as text. You can manually remove text formatting in the worksheet by removing the single quote mark (') before each number. Alternatively, you can remove text formatting by:

 

Method 1: Text to Number Command

  1. Highlight all of the cells that contain numbers that are formatted as text. To change all of the columns at the same time, click the Select Entire Worksheet button in the upper left corner of the worksheet.

  2. Click the Data | Data | Text to Number command.

  3. All of the numbers in the highlighted section will be right-aligned and formatted as numbers.

 

Method 2: Save as .DAT File

  1. Open the data in the worksheet using File | Open.

  2. Choose File | Save As.

  3. In the Save as type list, choose DAT Data (*.dat) file. Type a File name and click the Save button.

  4. Choose Tab, Comma, Semicolon, or Space as the delimiter.

  5. Choose (none) as the Text Qualifier (this is important - this removes the text formatting from numbers). Click OK.

  6. Open the new file in the worksheet, and the numbers will be right-aligned.

 

 

See Also

Paste Special - Worksheet

Text to Number