jr.9

PostsComments

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

/close

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

thanks

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

ah okay

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

cast it using (Decimal) or Convert.ToDecimal()?

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

sadly not possible, these spreadsheets come in a certain way and have to stay that way

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

I appreciate the help, thank you both

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

Anyways, I think I'm fine if it's true that doubles are accurate in the scale I'm using them in

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

maybe I'm using it wrong somehow, but when I tried that it was still returning a double

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

That doesn't seem to actually DO anything, I don't know why... I think it may be a bug? The library seems kinda dead sadly

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

follow up question: Should I typecast it or use Convert.ToDecimal()?

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

I thought decimal was safe to work with?

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

Nah, two decimal points at most and mostly just tens of dollars

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

Ty

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

no matter what I use, I think the issue may be the same - I'm mostly just curious how inaccurate doubles are when working with small values like this and if it's feasible to convert to decimal

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

not using ExcelDataReader, it reads values / data as the datatype it's saved as

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

you're fine, I appreciate you taking the time to look at it

35 replies

CC#

•Created by jr.9 on 1/9/2023 in #help

❔ Can you convert from an excel sheet double to decimal for currency math?

I don't have a choice, excel stores numbers as doubles

35 replies