Excel problem

[waller]

Happy Easter Everyone!

Not sure if this is an error or if I'm the one making an error :D

Anyway, I've made some software with 3 calculations within the record, which are all working fine. I want the end user to be able to add these up and so exported the record to Excel. In Excel, this doesn't work because the information is stored as text, not numbers. So I have to convert each field back to number.

Any idea how to fix this? (I'm using decimal editors, because the results need to be in $ and currrency editors use local currency.)

Thanks Guys,

Waller

[pete]

Excel has functions to convert between numbers and text so you can just have those in an excel file and then import the data and run those functions, no?

[waller]

Excel has functions to convert between numbers and text so you can just have those in an excel file and then import the data and run those functions, no?

Yeah, I've already done that. I just wondered if there was a way of avoiding it, to have as few steps as possible for buyers. If not, it's not a major problem

thanks

Waller

[TigerSoftware]

Yeah, I've already done that. I just wondered if there was a way of avoiding it, to have as few steps as possible for buyers. If not, it's not a major problem

thanks

Waller

Unfortunately there isn't a way to avoid it Waller. I know I am a meanie for saying that. hehe



Thomas

[waller]

Oh well, I'm getting faster at it now. I was just trying to avoid having to explain it all in the videos and the dreaded user manual. But I finished all of them today and so am feeling very virtuous, despite your meanness :p