Hyphen or minus sign

Hello @hotelwww
Thanks for getting in touch,

Format Cells as Text

• If you want the minus sign or hyphen to appear as text and not affect calculations:
  1. Select the range of cells you want to adjust. ex that entire column
  2. Go to Format > Number > Plain Text.
  3. And the minus signs should display correctly without being calculated.

Check for Automatic Formatting or Corrections

• In Google Sheets, the Auto-correct feature may replace certain characters. To disable auto-corrections:
  • Go to Tools > Preferences and check for any automatic replacements that could be affecting your entries.

Let me know if this helps!

Thanks
Abdullah

Hi @westerndeal
The value arrives with the (-) sign but it is being ignored. It was working in a previous version of the plugin.

I also followed the instructions I sent, but I had no success.

https://snipboard.io/FMaZhk.jpg

https://snipboard.io/caT9Ml.jpg

I tested it in an environment with the following configurations:

• WordPress 6.6.2 ( https://snipboard.io/6CFmrw.jpg )
• CF7 Google Sheet Connector v5.0.15 ( https://snipboard.io/bVwhvf.jpg )
• Contact Form 7 v6.0 ( https://snipboard.io/bVwhvf.jpg )
• Twenty Twenty-Four v1.3 ( https://snipboard.io/ErPyoT.jpg )
• PHP 8.3 ( https://snipboard.io/5KQTrV.jpg )
• Form with text field ( https://snipboard.io/qmOVTX.jpg )
• Spreadsheet with text cell ( https://snipboard.io/LzXIW6.jpg )
• Enable formula corrections, disable ( https://snipboard.io/t96W3T.jpg )
• Example form ( https://snipboard.io/kYB6nV.jpg )

It didn’t work, I still received it without the negative sign.

Hi @hotelwww,

Due to security reasons, we have removed those characters but

Have you tried the following

Format -> Number -> Custom Number Format as -##.##########

Let us know if that doesn’t work.

Also, please let us know which type of Field ( Number, text ) you are using for the latitude and longitude data and which third plugin you are using for it.

Thanks
Abdullah

Hi @abdullah17

It should be noted that the solution presented does not cover general problems, especially with regard to the criteria needed to deal with latitude and longitude numbers, which can be positive or negative and operate in a global context.

@abdullah17

See the problem on the map ( https://snipboard.io/hlxfS9.jpg ). Instead of showing Brazil, the location shows Saudi Arabia.

I use https://awesome-table.com/, with a template like this https://app.awesome-table.com/-Lp2XprOCAbEEVLcqnj0/preview, the application is at this other URL https://www.iluminando.app.br/ .

• This reply was modified 4 months ago by hotelwww.

Hello @hotelwww,

Thanks for the confirmation that latitude and longitude are still not saved with negative and positive.

Can you email us [email protected]?and the temp staging site to take a closer look and help you further?

Thanks
Abdullah