Numbers saved as values in error, how to converts back

Discuss the spreadsheet application

Numbers saved as values in error, how to converts back

Postby kenkreger » Thu Feb 27, 2020 11:49 pm

Somehow when I saved my spreadsheet all the numbers were saved with a ' in front and now are a "value" instead of a number I believe. is the a way to strip all the ' from in front of every number without starting over?
Open Office 4.1.1
kenkreger
 
Posts: 1
Joined: Thu Feb 27, 2020 11:32 pm

Re: Numbers saved as values in error, how to converts back

Postby Villeroy » Fri Feb 28, 2020 12:50 am

How exactly did this happen? Is it a text file (csv)? A text file is NOT a spreadsheet.
Did you copy and paste from a web site?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28537
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 6 guests