Ask Your Question
0

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

Comments

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
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 27 times

Last updated: Sep 11