Ask Your Question

Blank chart for dates and currency

asked 2017-11-01 04:24:23 +0200

I'm trying to plot my finances, but my chart comes up blank.

Here's a link to it:

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-11-01 06:02:05 +0200

KH gravatar image

updated 2017-11-01 06:27:19 +0200

The cells in the "balance" column are all quoted, which makes them behave as text even if you try to change the cell format to something else. To see this, select a cell and look at the formula bar. You can also see it if you double click to edit.

There are several ways to fix this. Using Find and Replace to remove the quote seems to be the best general solution. See:

edit flag offensive delete link more


Ah, thank you, I fixed this with the dates but didn't think to do it with the currency.

EmergencyTemporalShift gravatar imageEmergencyTemporalShift ( 2017-11-02 05:06:28 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-01 04:24:23 +0200

Seen: 31 times

Last updated: Nov 01 '17