Skip navigation

Problems exporting to Excel with Value format

415 Views 4 Replies Latest reply: Nov 7, 2013 8:44 AM by catmankee RSS
catmankee Level 1 Level 1 (0 points)
Currently Being Moderated
Nov 1, 2013 11:36 AM

Hi!

I just used the new version of Numbers for the first time with some sheets I already used with previous version (it's a list of jobs I've done that I pass to my colleague that uses Excel) and I noticed a bug when I share (or I export) to Excel format (no matters if .xlsx or .xls):

Each cell where there's a value number with symbol (e.g.: "€ 50,00“) when in Excel appears with a "--2" after symbol (e.g.: "€--2 50,00") and cell is not in Value style but in "customized 1".

No matters if I use "thousand separator" and "value style" flags

What's the solution?

thanks a lot

 

here's an example

numbers file

Schermata 2013-11-01 alle 19.30.50.png

and same file exported in Excel

Schermata 2013-11-01 alle 19.32.24.png

iMac (21.5-inch, Late 2012), OS X Mavericks (10.9)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.