Suffix mm

[kashifjillani]

Hello Friends,

I want to use a suffix mm in the figures I put in cells.

I tried the custom cell #"mm" which works but it doesnt work when I try 3-8 mm, 4-5 mm and such data.

Is there some expert who knows it?

 

[villy]

Try...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Range("A1") & " mm"
End Sub

 

[villy]

Try vba code

 

[kashifjillani]

@ villy

how to use VB code in MS Excel 2007?

 

[kashifjillani]

Got the way to use the code BUT,

Villy, after running the code you sent, when i put in the value

e.g.

3-4

it appears as

40636mm

can you help on it again, thanks.

 

[R Pelle]

Don't ask me why .... but @" mm" works for me (Excel 2007)

Rob

 

[kashifjillani]

Wow, @ "mm" also work for me, that was really a short cut, thanks.