Inserting data into a cell with a userform in the same format

[Smurlos]

Afternoon,

I have a userform with 4 text boxes. One of the boxes you have to enter in an amount. i.e. £25.52

This value gets put into cell E17 in my spreadsheet.

When I click the button and it puts it in, it puts it in the cell as "£25.52" with left alignment and does not apply it as the accounting style, as set to that cell. The same happens if I just type "25.52" instead.

I also have a formula applied so that if E18 is "Yes", E19 will display "£0.00" otherwise, E19 should display the value of E17. And then column E has a total at the bottom of the values in Column E. Even when "£25.52" or "25.52" is entered in, it comes up in cell E19 as 25.52 (not with accounting style) but it doesn't add up in the sum at the bottom of the column.

Can anyone tell me how to fix this please?

Many thanks!

[solnajeff]

Hi

It depends how you are transferring the data. to retain the original formatting you can use something like

Please Login or Register  to view this content.

Regards

Jeff

[Smurlos]

I had to put ".value" on the end of the text box name in my coding doh! All fixed though. Thanks anyway