PDA

View Full Version : Solved: number format 0.00 €/m²



white_flag
01-26-2011, 03:42 AM
Hello again

I need your help:

I like to format numbers from cell like this 0.00 €/m² and 0.00 m² via VBA
I have this line:


Sheets(strSheetName).Range("B" & i + 1).NumberFormat = "0,00"


what will be the code for 0.00 €/m²

thx

white_flag
01-26-2011, 04:47 AM
Sheets(strSheetName).Range("F" & i + 1).NumberFormat = "0.00"" €/m²"""