I want to create m3 numbers in Excel 'format cells' either as 'custom' or 'special'

Question

I want to monitor my water consumption bills in Excel and want to calculate used water volume per annum or per month

Answer 1

Alternate method is a macro

Sub Cubic_Meters()

    Selection.NumberFormat = "0"" m" & Chr(179) & """"

End Sub

Select the number cells and run the macro.

Or sheet event code for automatic when hit Enter key after input

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column > 3 Then Exit Sub  'limited to columns A:C

    With Target

        .NumberFormat = "0"" m" & Chr(179) & """"

    End With

End Sub

Gord

Answer 2

Just go to Format cells > Custom > and add "m3" for cubic metre

You can apply formulas on it as well

Answer 3

Thanks for responding to my inquiry. I am not a 'program-writer' to venture 'inside' the Excel program for a solution.

The next response from Mr Patel seems to me something I might be able to execute in the 'format cell' part of Excel.

Thanks again for responding to my request.

Answer 4

Glad we were able to help you.

If you found my response helpful, please mark it as an answer for others to see.

Thanks!

Answer 5

In that case you should mark Ketul_Patel's solution as the answer.

Gord