cell formatting

[juan1]

Can a cell be formatted to perform a multiplication when inputting a number in that cell?
Say you know all inch numbers to type in many cells, but want the values to show as mm.


thanks for any help
Juan

 

[dreid1011]

Can a cell be formatted to perform a multiplication when inputting a number in that cell?
Say you know all inch numbers to type in many cells, but want the values to show as mm.


thanks for any help
Juan

I don't believe that cell formatting can do that, but it could be possible with some vba worksheet change events. Otherwise, you would need to use a helper column to perform the conversions.

 

[juan1]

thanks can anyone write me this code?
Juan

 

[dreid1011]

I'm sure we can come up with something. We'll need some more information first though.

Can you provide a layout of your sheet(s), sheet names, which cells should convert inches to mm, etc. Please provide as much information as possible.

 

[Rick Rothstein]

thanks can anyone write me this code?
Juan

If you don't mind using a helper column, then you can use this simple formula...

=CONVERT(A1,"in","mm")

Change the cell reference as needed.