Ask Your Question

Blank chart for dates and currency [closed]

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

updated 2020-07-21 13:52:13 +0200

Alex Kemp gravatar image

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

Here's a link to it:

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-21 13:52:20.111565

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

Question Tools

1 follower


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

Seen: 57 times

Last updated: Nov 01 '17