Getting rid of leading zeros in columns?

User Help for GS-Calc

Getting rid of leading zeros in columns?

Postby Crash-14 » Fri Oct 24, 2014 10:29 am

After completing my SUMIF problem, here, the next one involves leading zeros. I have a column of numbers and roughly 100 of them have a leading zero that I want to get rid of. I want regular numbers here. How do I format them to remove the leading zero? I tried using cell format and ended up creating a custom style that took away all numbers.
Crash-14
 
Posts: 18
Joined: Wed Oct 22, 2014 5:58 am

Re: Getting rid of leading zeros in columns?

Postby citadel5 » Fri Oct 24, 2014 11:10 am

The default number format doesn't include any leading zeroes so if you imported the data from a text file, it seems that
(1) you cleared the "Convert text to numbers" option and you have text strings in that column
or
(2) you selected the option to parse formatted numbers and save their styles when importing that text file
or
(3) those values are represented in that text file as text strings, enclosed in quotation marks.

If the table status bar describe these cells as "Text", select them and use the "Edit > Convert > Labels To Numbers" command.
User avatar
citadel5
 
Posts: 117
Joined: Tue Apr 20, 2010 11:58 pm

Re: Getting rid of leading zeros in columns?

Postby Crash-14 » Fri Oct 24, 2014 1:46 pm

Got it, thanks for the info.
Crash-14
 
Posts: 18
Joined: Wed Oct 22, 2014 5:58 am


Return to GS-Calc Support

Who is online

Users browsing this forum: No registered users and 1 guest