Almyta Systems Homepage
Forum Home Forum HomeSBS and AID Software packagesSBS/AID Order Entry
  New Posts New Posts RSS Feed - Importing values with decimals
  FAQ FAQ  Forum Search   Register Register  Login Login

This site is dedicated to Almyta Systems Inventory Software

Importing values with decimals

 Post Reply Post Reply
Author
Message
hugoe View Drop Down
Newbie
Newbie


Joined: 02 Jul 2013
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote hugoe Quote  Post ReplyReply Direct Link To This Post Topic: Importing values with decimals
    Posted: 12 Jul 2013 at 11:17am
I need help to enter quantities, prices or costs with decimals when importing data.
I cannot use the point, and error “Contains invalid syntax” appears. If I change the dot by a comma the system does not input the decimals.
How should I do it? Is there any way of doing it?
Thanks
Back to Top
hugoe View Drop Down
Newbie
Newbie


Joined: 02 Jul 2013
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote hugoe Quote  Post ReplyReply Direct Link To This Post Posted: 12 Jul 2013 at 12:14pm
Problem solved.
I was using (Regional options) the comma as a decimal symbol. I changed for a dot.
For anyone having the same problem

Back to Top
Debra View Drop Down
Senior Member
Senior Member


Joined: 22 Aug 2011
Points: 535
Post Options Post Options   Thanks (0) Thanks(0)   Quote Debra Quote  Post ReplyReply Direct Link To This Post Posted: 12 Jul 2013 at 12:40pm
Before you save your spreadsheet, reformat numbers to be in ###0.0 format
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10
Copyright ©2001-2011 Web Wiz Ltd.

This page was generated in 0.125 seconds.