ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   format cels to get " m³/h " (https://www.excelbanter.com/excel-discussion-misc-queries/213933-format-cels-get-m%C2%B3-h.html)

JJ

format cels to get " m³/h "
 
how can i format cels to get " m³/h " after a number

Steve Jones

format cels to get " m³/h "
 
FORMAT, CELLS, CUSTOM

select @ " your text" and OK


"JJ" wrote in message
...
how can i format cels to get " m³/h " after a number




David Biddulph[_2_]

format cels to get " m³/h "
 
Format/ Cells/ Number/ Custom: General" m³/h "
--
David Biddulph

"JJ" wrote in message
...
how can i format cels to get " m³/h " after a number




Satti Charvak[_2_]

format cels to get " m³/h "
 
Right click the cell,

select "Format cells"

now select "Custom" in the category list. and on the right side

in the "Type:" field enter

#,###" m³/h "

It should work.

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"JJ" wrote:

how can i format cels to get " m³/h " after a number



All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com