User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Numbers saved as values in error, how to converts back
2 posts
• Page 1 of 1
Numbers saved as values in error, how to converts back
by 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
by 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?
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
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
-
Villeroy - Volunteer
- Posts: 28537
- Joined: Mon Oct 08, 2007 1:35 am
- Location: Germany
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 6 guests
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|