Numbers saved as values in error, how to converts back

kenkreger · Post 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?

edit this topic's initial post · Post 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?

Numbers saved as values in error, how to converts back

Numbers saved as values in error, how to converts back

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