Friday 5th April, 2024, page-57

  1. 2,539 Posts.
    lightbulb Created with Sketch. 20

    I do think it’s not a good idea to delete extra spaces from pins willy-nilly.

    However I think it was quite clear what zipperlip intended and that removing spaces around the decimal point would improve participation.

    So, I propose using the “SUBSTITUTE” function as shown below to remove a space either side of a decimal point, to be replaced with just the decimal point itself.


    https://hotcopper.com.au/data/attachments/6084/6084879-1089eb8bcc9b959ba8c02b714eb0d998.jpg


    Regards

    John
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.