We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Make whole spreadsheet numbers with value..

asked 2019-09-10 00:22:32 +0200

clos911 gravatar image

I have to keep Value Highlighting on in order to see if the numbers I input are actually a number my pivot table will sum up.. I constantly have to reformat my cells and use Data> Text to Column in order to get the number to be a number...

any way to default the whole spreadsheet as numbers?

edit retag flag offensive close merge delete


Verify the cells are not formatted as text, if so maybe it happens when you import the numbers.

m.a.riosv gravatar imagem.a.riosv ( 2019-09-10 11:38:37 +0200 )edit

They are formatted as numbers, also pasting numbers that have value does will no longer have value value once pasted...

clos911 gravatar imageclos911 ( 2019-09-10 21:45:16 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-09-11 11:44:47 +0200

erAck gravatar image

Pasting from where (which source format) and how? If the source is HTML it might help to use Paste Special (Shift+Ctrl+V) and select Unformatted Text which uses the Text/CSV import, and if it's a table use Space separator and Merge delimiters.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-09-10 00:22:32 +0200

Seen: 55 times

Last updated: Sep 11 '19