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:
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.
Click the Data | Data | Text to Number command.
All of the numbers in the highlighted section will be right-aligned and formatted as numbers.
Open the data in the worksheet using File | Open.
Choose File | Save As.
In the Save as type list, choose DAT Data (*.dat) file. Type a File name and click the Save button.
Choose Tab, Comma, Semicolon, or Space as the delimiter.
Choose (none) as the Text Qualifier (this is important - this removes the text formatting from numbers). Click OK.
Open the new file in the worksheet, and the numbers will be right-aligned.
Paste Special - Worksheet
Text to Number