Forum Discussion

Phil-365's avatar
Phil-365
Copper Contributor
Apr 07, 2020

excel Variables

Hi

Im trying to use a numeric system of Version numbers for my various programs eg 1.0000 however i seem to try and declare the variable when collecting the Version number from a selected cell, the number is either missing the end zero or the number is placed in quotation Marks any help would be gratefully appreciated

Macros and VBA

3 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Apr 07, 2020

    Phil-365 

     

    You can use number formatting to increase the number of figures behind the decimal point, so that if desired it will display your 1 as 1.0000 and still be a number, a number that could be incremented to 1.0001 by adding that small fraction to it.

    • Phil-365's avatar
      Phil-365
      Copper Contributor
      Apr 13, 2020

      Sorry for late reply i got that excited because at last i was given the solution I forgot to reply. Once again please accept myapologiesmathetes 

  • mtarler's avatar
    mtarler
    Silver Contributor
    Apr 07, 2020

    Phil-365  When you enter a number it will store it as a number so 1.000 is just 1 but if you store it as text "1.000" then it is text "1.000"

    If you want it to store/keep those extra '0's you will need to store it as text

Resources