SoftMaker.com

As clarification to my prior post... 1) This number: -$57.00 can NOT BE ENTERED MANUALLY. When I try to enter it manually Planmaker displays an error and will not accept it. 2) This number: -$57.00 can NOT BE IMPORTED as a number. Planmaker treats it only as text. Even the VALUE function can't conve...

Hi Woody... I'm not entering these numbers manually. I'm importing them. As far as I can tell, it isn't possible to manually enter numbers in the format I described. To summarize: -$57.00 fails $-57.00 is ok My import file from my bank can't be changed and Planmaker fails to recognize it as number w...

It's typical for banks and brokerages to export number as text with a minus sign and dollar sign to the left. Like this... -$100 Cut and paste back as unformatted text doesn't help with this nor do the other suggested conversion hacks. The VALUE function doesn't work either Is there an easy way to c...

It's hard to avoid importing things like this... -$100 from banks and other organizations. I have not found a way to convert text values like this -$100 to number or currency format when using PlanMaker. Is there a way to do it?

What if you have a value like this... -$100.00 I can't find a way to convert to number if the value contains a minus sign and dollar sign on the left side.

When I import financial data that includes a negative sign on the left, even if I designate the column as currency or number format, Planmaker imports the data as text. For example, characters like these... -$1015.00, -$105.57, -$722.43 are imported as text. I tried the Format / Cell options to spec...