Storing Data from Form as Number

[rigate]

I have a simple data input form popup on an Excel spreadsheet. After the data is inputted it populates the spreadsheet. I'm trying to get the value to be saved in number format instead of text format. I've tried formatting the Excel spreadsheet, but it always wants to put the value in as text. Any suggestions?

Thanks!

 

[ColinKJ]

Hi rigate

You might want to try something like

a = Val(InputBox(""))

ColinKJ

 

[rigate]

Thanks for the reply! Where do I use that code?

 

[ColinKJ]

Hi rigate,

You say in your origianl post that you have "a simple data input form popup ".

I assumed this to be a VBA code. If it is, my suggestion would go in your code.

ColinKJ

 

[rigate]

I do have VBA code. I don't understand what "a" equals or what the rest of it means. I'm a beginner. :-/

 

[ColinKJ]

Hi,

If you can paste a copy of your code that takes the input box, I can tell you what to change.

Regards

Colin